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

Line 289: FROM per_periods_of_service service,

285: and bd.balance_dimension_id = db.balance_dimension_id;
286:
287: Cursor C2 is
288: SELECT max(service.date_start) start_date
289: FROM per_periods_of_service service,
290: per_all_assignments_f ass
291: WHERE ass.assignment_id = p_assignment_id
292: AND ass.person_id = service.person_id
293: AND service.date_start <= l_effective_date;

Line 441: FROM per_periods_of_service service,

437: p_start_date date;
438: l_effective_date date;
439: cursor c1 is
440: SELECT max(service.date_start) start_date
441: FROM per_periods_of_service service,
442: per_all_assignments_f ass
443: WHERE ass.assignment_id = p_assignment_id
444: AND ass.person_id = service.person_id
445: AND service.date_start <= l_effective_date;