DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 2188: from per_org_structure_elements

2184: --Cursor to find the parent id from the org id
2185: CURSOR c_find_parent_id(c_org_id in number
2186: ,c_version_id in number) IS
2187: select organization_id_parent
2188: from per_org_structure_elements
2189: where organization_id_child = c_org_id
2190: AND org_structure_version_id = c_version_id
2191: AND business_group_id = p_business_group_id;
2192:

Line 3317: from per_org_structure_elements

3313: --Cursor to find the parent id from the org id
3314: CURSOR c_find_parent_id(c_org_id in number
3315: ,c_version_id in number) IS
3316: select organization_id_parent
3317: from per_org_structure_elements
3318: where organization_id_child = c_org_id
3319: AND org_structure_version_id = c_version_id
3320: AND business_group_id = p_business_group_id;
3321: