DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PER_ALL_ASSIGNMENTS_F

Line 121: per_all_assignments_f paf,

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')
125: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 129: from per_all_assignments_f paf2

125: and paa1.payroll_action_id = ppa1.payroll_action_id
126: and paa1.assignment_id = paf.assignment_id
127: and paf.effective_start_date =
128: (select max(paf2.effective_start_date)
129: from per_all_assignments_f paf2
130: where paf2.assignment_id= paf.assignment_id
131: and paf2.effective_start_date
132: <= ppa1.effective_date)
133: and paf.effective_end_date >= ppa1.start_date