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_CORE_FF_UDFS dependencies on PER_PERIODS_OF_SERVICE

Line 2695: per_periods_of_service pps

2691: CURSOR get_termination_date(l_date_earned date,
2692: l_assignment_id number) IS
2693: select actual_termination_date
2694: from per_assignments_f paf,
2695: per_periods_of_service pps
2696: where paf.assignment_id = l_assignment_id
2697: and l_date_earned between paf.effective_start_date and
2698: paf.effective_end_date
2699: and paf.PERIOD_OF_SERVICE_ID = pps.period_of_service_id;

Line 3343: from per_periods_of_service PDS,

3339: ,p_assignment_id number) is
3340: select pds.actual_termination_date
3341: ,pds.last_standard_process_date
3342: ,pds.final_process_date
3343: from per_periods_of_service PDS,
3344: per_assignments_f ASS
3345: WHERE PDS.actual_termination_date <= p_date_earned
3346: AND PDS.period_of_service_id = ASS.period_of_service_id
3347: AND p_date_earned BETWEEN ASS.effective_start_date