DBA Data[Home] [Help]

APPS.PAY_NL_IZA_UPLOAD dependencies on HR_ORGANIZATION_UNITS

Line 116: from HR_ORGANIZATION_INFORMATION hoi, HR_ORGANIZATION_UNITS hou

112:
113:
114: cursor csr_organization_id(v_client_number varchar2,v_sub_emplr_number varchar2,v_bg_id number) IS
115: select hoi.organization_id
116: from HR_ORGANIZATION_INFORMATION hoi, HR_ORGANIZATION_UNITS hou
117: where ORG_INFORMATION_CONTEXT='NL_IZA_REPO_INFO'
118: and lpad(ORG_INFORMATION1,3,'0') = v_client_number
119: and lpad(ORG_INFORMATION2,3,'0') = v_sub_emplr_number
120: and hou.ORGANIZATION_ID = hoi.organization_id