DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PER_ALL_PEOPLE_F

Line 120: per_all_people_f ppf,

116: select 'TRANSFER_ACT_ID=P', assignment_action_id
117: from hr_all_organization_units hou,
118: hr_all_organization_units hou1,
119: hr_locations_all loc,
120: per_all_people_f ppf,
121: per_all_assignments_f paf,
122: pay_assignment_actions paa1,
123: pay_payroll_actions ppa1
124: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 141: from per_all_people_f ppf2

137: and loc.location_id = paf.location_id
138: and ppf.person_id = paf.person_id
139: and ppf.effective_start_date =
140: (select max(ppf2.effective_start_date)
141: from per_all_people_f ppf2
142: where ppf2.person_id= paf.person_id
143: and ppf2.effective_start_date
144: <= ppa1.effective_date)
145: and ppf.effective_end_date >= ppa1.start_date