You have to check in Peoplecode that if there is any future dated row after the date (01march2010) then also update the those future dated Items

Cheers
Simrose

You can get the Item(Index) of the row of 01 march and have the Total active rowcount
for the EMPLID and Loop the remaining item to Update the Futre dated rows

for &i=Item(Index)+1 to activerowcount
.....
Update CI code for future rows
.....

End -for

Thanks for the Suggestion . But i am not able to loop at the Compensation level (child scroll).
I am able to pick up future rows for the Job , but the same future is not getting updated at the compensation level. Here is the code attached please suggest.

For &j = &oJobFoundIndex + 1 To &TotalRowCount

&JOBItm = &JOBCol.Item(&j);
If &JOBItm.Action <> "PAY" Then
rem if jobitm.currency_code <> &JobCurCode ;

&compensationnext = "Y";
&CompIndex = &j;
&LogFile.WriteLine("COMPINDEX :- " | &CompIndex);
End-If;
End-For;
If &compensationnext = "Y" Then
rem &COMPENSATIONItm = &COMPENSATIONCol.Item(&CompIndex);
&JOBItm = &JOBCol.Item(&CompIndex);

&COMPENSATIONCol1 = &JOBItm.COMPENSATION;

Local integer &oCompensationCount1;
Local string &oCompensationFoundFlag1;
&oCompensationFoundFlag1 = "N";
For &oCompensationCount1 = 1 To &COMPENSATIONCol1.Count
&LogFile.WriteLine(" Compensation: " | &oCompensationCount1);
&COMPENSATIONItm1 = &COMPENSATIONCol1.item(&oCompensationCount1);

&COMPENSATIONItm1.COMP_RATECD = &CompRateCd1;
&COMPENSATIONItm1.COMP_EFFSEQ = &Compeffseq;

&COMPENSATIONItm1.COMPRATE_1 = &CompComprate1;
&COMPENSATIONItm1.COMP_FREQUENCY_1 = &CompFrequency;

end-if;

since compensation is child of job it will have the same Effective date

Try catching effdt then ITem