eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_YEAR_END_EXTRACT dependencies on STANDARD

Line 1151: and nvl(pos.LAST_STANDARD_PROCESS_DATE,pos.actual_termination_date)

1147: and ye_asg.effective_end_date = asg.effective_end_date
1148: and asg.period_of_service_id = pos.period_of_service_id
1149: and ye_asg.payroll_id = ye_roll.payroll_id
1150: and pos.actual_termination_date is not null
1151: and nvl(pos.LAST_STANDARD_PROCESS_DATE,pos.actual_termination_date)
1152: between
1153: nvl(ye_asg.effective_start_date,
1154: nvl(ye_roll.start_previous_year,ye_roll.start_year))
1155: and least(ye_asg.effective_end_date,ye_roll.end_year))

Line 1167: and nvl(pos.LAST_STANDARD_PROCESS_DATE,pos.actual_termination_date)

1163: and ye_asg.effective_end_date = asg.effective_end_date
1164: and asg.period_of_service_id = pos.period_of_service_id
1165: and ye_asg.payroll_id = ye_roll.payroll_id
1166: and pos.actual_termination_date is not null
1167: and nvl(pos.LAST_STANDARD_PROCESS_DATE,pos.actual_termination_date)
1168: between
1169: nvl(ye_asg.effective_start_date,
1170: nvl(ye_roll.start_previous_year,ye_roll.start_year))
1171: and least(ye_asg.effective_end_date,ye_roll.end_year))