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

Line 221: per_periods_of_service PDS

217: paf.effective_end_date
218: from
219: per_assignments_f paf,
220: pay_assignment_actions paa,
221: per_periods_of_service PDS
222: where
223: paf.person_id >= stperson and
224: paf.person_id <= endperson and
225: paf.primary_flag = 'Y' and

Line 250: per_periods_of_service PDS

246: from
247: per_assignments_f paf,
248: pay_assignment_actions paa,
249: pay_population_ranges ppr,
250: per_periods_of_service PDS
251: where
252: -- paf.person_id >= stperson and
253: -- paf.person_id <= endperson and
254: ppr.payroll_action_id = pactid and

Line 308: per_periods_of_service pds

304: paa.payroll_action_id,
305: paf.effective_end_date
306: from per_assignments_f paf,
307: pay_assignment_actions paa,
308: per_periods_of_service pds
309: where paf.person_id between stperson
310: and endperson
311: and paf.primary_flag = 'Y'
312: and paf.assignment_type = 'E'

Line 406: per_periods_of_service pds

402: paf.effective_end_date
403: from
404: per_assignments_f paf,
405: pay_assignment_actions paa,
406: per_periods_of_service pds
407: where
408: paf.person_id >= stperson and
409: paf.person_id <= endperson and
410: paf.primary_flag = 'Y' and

Line 440: per_periods_of_service pds

436: from
437: per_assignments_f paf,
438: pay_assignment_actions paa,
439: pay_population_ranges ppr,
440: per_periods_of_service pds
441: where
442: -- paf.person_id >= stperson and
443: -- paf.person_id <= endperson and
444: ppr.payroll_action_id = pactid and