DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 163: FROM per_org_structure_elements

159: --
160: CURSOR c_get_parent_id(c_org_id IN NUMBER
161: ,c_version_id IN NUMBER) IS
162: SELECT organization_id_parent
163: FROM per_org_structure_elements
164: WHERE organization_id_child = c_org_id
165: AND org_structure_version_id = c_version_id
166: AND business_group_id = p_business_group_id;
167:

Line 1049: FROM per_org_structure_elements

1045: --
1046: CURSOR c_get_parent_id(c_org_id IN NUMBER
1047: ,c_version_id IN NUMBER) IS
1048: SELECT organization_id_parent
1049: FROM per_org_structure_elements
1050: WHERE organization_id_child = c_org_id
1051: AND org_structure_version_id = c_version_id
1052: AND business_group_id = p_business_group_id;
1053: