APPS.PAY_CA_T4_REG dependencies on PER_PERIODS_OF_SERVICE

Line 262: per_periods_of_service PDS

258: pay_assignment_actions paa,
259: ff_archive_items fai,
260: ff_contexts fc,
261: ff_archive_item_contexts faic,
262: per_periods_of_service PDS
263: where paf.person_id between stperson
264: and endperson
265: and paf.primary_flag = 'Y'
266: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 298: per_periods_of_service PDS

294: ff_archive_items fai,
295: ff_contexts fc,
296: ff_archive_item_contexts faic,
297: pay_population_ranges ppr,
298: per_periods_of_service PDS
299: where --paf.person_id between stperson
300: -- and endperson
301: paf.primary_flag = 'Y'
302: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 375: per_periods_of_service PDS

371: pay_assignment_actions paa,
372: ff_archive_items fai,
373: ff_contexts fc,
374: ff_archive_item_contexts faic,
375: per_periods_of_service PDS
376: where paf.person_id between stperson
377: and endperson
378: and paf.primary_flag = 'Y'
379: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 494: per_periods_of_service PDS

490: pay_assignment_actions paa,
491: ff_archive_items fai,
492: ff_archive_item_contexts faic,
493: ff_contexts fc,
494: per_periods_of_service PDS
495: where paf.person_id >= stperson
496: and paf.person_id <= endperson
497: and paf.primary_flag = 'Y'
498: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 535: per_periods_of_service PDS

531: ff_archive_items fai,
532: ff_archive_item_contexts faic,
533: ff_contexts fc,
534: pay_population_ranges ppr,
535: per_periods_of_service PDS
536: where --paf.person_id >= stperson
537: --and paf.person_id <= endperson
538: paf.primary_flag = 'Y'
539: and paf.effective_start_date = (select max(paf2.effective_start_date)