DBA Data[Home] [Help]

APPS.PAY_CA_T4_REG dependencies on PAY_POPULATION_RANGES

Line 225: pay_population_ranges ppr

221: pay_assignment_actions paa,
222: ff_archive_items fai,
223: ff_contexts fc,
224: ff_archive_item_contexts faic,
225: pay_population_ranges ppr
226: where --paf.person_id between stperson
227: -- and endperson
228: paf.primary_flag = 'Y'
229: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 297: pay_population_ranges ppr,

293: pay_assignment_actions paa,
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'

Line 453: pay_population_ranges ppr

449: pay_assignment_actions paa,
450: ff_archive_items fai,
451: ff_archive_item_contexts faic,
452: ff_contexts fc,
453: pay_population_ranges ppr
454: where --paf.person_id >= stperson
455: --and paf.person_id <= endperson
456: paf.primary_flag = 'Y'
457: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 534: pay_population_ranges ppr,

530: pay_assignment_actions paa,
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'