APPS.PAY_US_ACTION_ARCH dependencies on PER_ASSIGNMENTS_F

Line 540: per_assignments_f paf

536: lv_sql_string :=
537: 'select distinct paf.person_id
538: from pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: per_assignments_f paf
541: where ppa.business_group_id = ''' || ln_business_group_id || '''
542: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
543: fnd_date.date_to_canonical(ld_start_date) || ''')
544: and fnd_date.canonical_to_date(''' ||

Line 602: select /*+ INDEX(PAF PER_ASSIGNMENTS_F_N12)

598: ,cp_business_group_id in number
599: ,cp_start_date in date
600: ,cp_end_date in date
601: ) is
602: select /*+ INDEX(PAF PER_ASSIGNMENTS_F_N12)
603: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
604: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
605: paa.assignment_id,
606: paa.tax_unit_id,

Line 614: per_assignments_f paf

610: paa.assignment_action_id,
611: paa.payroll_action_id
612: from pay_payroll_actions ppa,
613: pay_assignment_actions paa,
614: per_assignments_f paf
615: where paf.person_id between cp_start_person_id
616: and cp_end_person_id
617: and paa.assignment_id = paf.assignment_id
618: and ppa.effective_date between paf.effective_start_date

Line 654: INDEX(PAF PER_ASSIGNMENTS_F_N12)

650: ,cp_start_date in date
651: ,cp_end_date in date
652: ) is
653: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)
654: INDEX(PAF PER_ASSIGNMENTS_F_N12)
655: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
656: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
657: paa.assignment_id,
658: paa.tax_unit_id,

Line 666: per_assignments_f paf,

662: paa.assignment_action_id,
663: paa.payroll_action_id
664: from pay_payroll_actions ppa,
665: pay_assignment_actions paa,
666: per_assignments_f paf,
667: pay_population_ranges ppr
668: where ppr.payroll_action_id = cp_payroll_action_id
669: and ppr.chunk_number = cp_chunk_number
670: and paf.person_id = ppr.person_id