DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1963: FROM per_org_structure_elements a

1959: CURSOR c_get_children ( c_org_str_ver_id IN Number
1960: ,c_org_id IN Number) IS
1961: SELECT os.organization_id_child
1962: FROM (SELECT *
1963: FROM per_org_structure_elements a
1964: WHERE a.org_structure_version_id = c_org_str_ver_id ) os
1965: START WITH os.organization_id_parent = c_org_id
1966: CONNECT BY os.organization_id_parent = PRIOR os.organization_id_child;
1967: