DBA Data[Home] [Help]

APPS.PAY_KR_HIA_PKG dependencies on HR_ORGANIZATION_UNITS

Line 113: hr_organization_units hou1,

109: SELECT DISTINCT asg.assignment_id,
110: asg.establishment_id
111: FROM per_assignments_f asg,
112: pay_payroll_actions xppa,
113: hr_organization_units hou1,
114: hr_organization_information hoi1
115: WHERE xppa.payroll_action_id = p_payroll_action_id
116: and hou1.business_group_id = g_pact.business_group_id --3506171
117: and hoi1.organization_id = hou1.organization_id