DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 135: ,hr_all_organization_units hou

131: SELECT hoi.org_information3
132: FROM hr_organization_information hoi
133: ,per_all_assignments paf
134: ,hr_soft_coding_keyflex hsc
135: ,hr_all_organization_units hou
136: WHERE paf.assignment_id = p_assignment_id
137: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
138: AND hsc.segment1 = hou.organization_id
139: AND hou.business_group_id = hoi.organization_id