APPS.HR_NL_ORG_INFO dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 79: FROM per_org_structure_versions sv

75: -- Cursor to return the current named hierarchy version.
76: --
77: CURSOR c_hierarchy_version(vp_organization_id NUMBER) IS
78: SELECT sv.org_structure_version_id, sv.version_number
79: FROM per_org_structure_versions sv
80: ,fnd_sessions ses
81: WHERE sv.organization_structure_id = named_hierarchy(vp_organization_id)
82: AND ses.session_id = USERENV('sessionid')
83: AND ses.effective_date BETWEEN sv.date_from

Line 867: CURSOR tax_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,

863:
864: --
865: -- Cursor which fetches Tax Organization list for the given HR Organization
866: --
867: CURSOR tax_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
868: l_org_id in hr_organization_units.organization_id%type) IS
869: SELECT tax_org_id,lev from hr_organization_information e,(
870: SELECT l_org_id tax_org_id,0 lev from dual
871: UNION

Line 2175: CURSOR iza_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,

2171:
2172: --
2173: -- Cursor which fetches IZA Organization list for the given HR Organization
2174: --
2175: CURSOR iza_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
2176: l_org_id in hr_organization_units.organization_id%type) IS
2177: SELECT iza_org_id,lev from hr_organization_information e,(
2178: SELECT l_org_id iza_org_id,0 lev from dual
2179: UNION