DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on PER_ASSIGNMENTS_F

Line 93: per_assignments_f paa

89: select distinct paa.assignment_id
90: from pay_payroll_actions xppa,
91: pay_payroll_actions rppa,
92: pay_assignment_actions rpac,
93: per_assignments_f paa
94: where xppa.payroll_action_id = p_payroll_action_id
95: and paa.person_id between p_start_person_id
96: and p_end_person_id
97: and rppa.business_group_id = g_pact.business_group_id

Line 247: per_assignments_f paa,

243: fnd_date.date_to_canonical(paa.effective_start_date)
244: from pay_assignment_actions pac,
245: pay_payroll_actions rppa,
246: pay_assignment_actions rpac,
247: per_assignments_f paa,
248: per_people_f pap,
249: per_periods_of_service pps,
250: hr_organization_units hou
251: where pac.assignment_action_id = p_assignment_action_id