DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 151: FROM per_org_structure_elements

147: --
148: CURSOR c_get_parent_id(c_org_id IN NUMBER
149: ,c_version_id IN NUMBER) IS
150: SELECT organization_id_parent
151: FROM per_org_structure_elements
152: WHERE organization_id_child = c_org_id
153: AND org_structure_version_id = c_version_id
154: AND business_group_id = p_business_group_id;
155:

Line 895: FROM per_org_structure_elements

891: --
892: CURSOR c_get_parent_id(c_org_id IN NUMBER
893: ,c_version_id IN NUMBER) IS
894: SELECT organization_id_parent
895: FROM per_org_structure_elements
896: WHERE organization_id_child = c_org_id
897: AND org_structure_version_id = c_version_id
898: AND business_group_id = p_business_group_id;
899: