DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 2253: from per_org_structure_elements

2249: --Cursor to find the parent id from the org id
2250: CURSOR c_find_parent_id(c_org_id in number
2251: ,c_version_id in number) IS
2252: select organization_id_parent
2253: from per_org_structure_elements
2254: where organization_id_child = c_org_id
2255: AND org_structure_version_id = c_version_id
2256: AND business_group_id = p_business_group_id;
2257:

Line 3414: from per_org_structure_elements

3410: --Cursor to find the parent id from the org id
3411: CURSOR c_find_parent_id(c_org_id in number
3412: ,c_version_id in number) IS
3413: select organization_id_parent
3414: from per_org_structure_elements
3415: where organization_id_child = c_org_id
3416: AND org_structure_version_id = c_version_id
3417: AND business_group_id = p_business_group_id;
3418: