DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on PER_ALL_ASSIGNMENTS_F

Line 100: per_all_assignments_f paf,

96: SELECT
97: 'TRANSFER_ACT_ID=P',paa.assignment_action_id
98: FROM pay_action_information pin,
99: per_all_people_f ppf,
100: per_all_assignments_f paf,
101: pay_action_interlocks pai,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_assignment_actions paa_arch

Line 236: per_all_assignments_f paf,

232: from hr_all_organization_units hou1,
233: hr_all_organization_units hou,
234: hr_locations_all loc,
235: per_all_people_f ppf,
236: per_all_assignments_f paf,
237: pay_assignment_actions paa1,
238: pay_payroll_actions ppa1
239: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 254: from per_all_assignments_f paaf2

250: and ppa1.effective_date between
251: ppf.effective_start_date and ppf.effective_end_date
252: and paf.effective_end_date = (
253: select max(paaf2.effective_end_date)
254: from per_all_assignments_f paaf2
255: where paaf2.assignment_id = paf.assignment_id
256: and paaf2.effective_start_date <= ppa1.effective_date
257: )
258: order by