DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on HR_ORGANIZATION_INFORMATION

Line 98: hr_organization_information hoi

94: pay_assignment_actions rpac,
95: per_assignments_f paa,
96: per_assignment_extra_info aei1,
97: per_assignment_extra_info aei2,
98: hr_organization_information hoi
99: where xppa.payroll_action_id = p_payroll_action_id
100: and paa.person_id between p_start_person_id
101: and p_end_person_id
102: and rppa.business_group_id = g_pact.business_group_id

Line 274: hr_organization_information hoi

270: per_assignment_extra_info aei2,
271: per_people_f pap,
272: per_periods_of_service pps,
273: hr_organization_units hou,
274: hr_organization_information hoi
275: where pac.assignment_action_id = p_assignment_action_id
276: and pac.assignment_id = rpac.assignment_id
277: and rpac.payroll_action_id = rppa.payroll_action_id
278: and rppa.action_type in ('R','Q')