DBA Data[Home] [Help]

APPS.PAY_DK_TC_DP_UPLOAD dependencies on HR_ORGANIZATION_UNITS

Line 173: FROM hr_organization_units hru, hr_organization_information hoi

169:
170: CURSOR csr_get_legal_employer(v_bg_id per_business_groups.business_group_id%TYPE)
171: IS
172: SELECT hoi.org_information1, hoi.org_information5
173: FROM hr_organization_units hru, hr_organization_information hoi
174: WHERE business_group_id = v_bg_id
175: and hru.organization_id = hoi.organization_id
176: and hoi.ORG_INFORMATION_CONTEXT = 'DK_LEGAL_ENTITY_DETAILS';
177: