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 3104: per_periods_of_service pps

3100: CURSOR get_termination_date(l_date_earned date,
3101: l_assignment_id number) IS
3102: select actual_termination_date
3103: from per_assignments_f paf,
3104: per_periods_of_service pps
3105: where paf.assignment_id = l_assignment_id
3106: and l_date_earned between paf.effective_start_date and
3107: paf.effective_end_date
3108: and paf.PERIOD_OF_SERVICE_ID = pps.period_of_service_id;

Line 3762: from per_periods_of_service PDS,

3758: ,p_assignment_id number) is
3759: select pds.actual_termination_date
3760: ,pds.last_standard_process_date
3761: ,pds.final_process_date
3762: from per_periods_of_service PDS,
3763: per_assignments_f ASS
3764: WHERE PDS.actual_termination_date <= p_date_earned
3765: AND PDS.period_of_service_id = ASS.period_of_service_id
3766: AND p_date_earned BETWEEN ASS.effective_start_date