DBA Data[Home] [Help]

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 5572: from per_org_structure_elements

5568: --Cursor to find the parent id from the org id
5569: CURSOR c_find_parent_id(c_org_id in number
5570: ,c_version_id in number) IS
5571: select organization_id_parent
5572: from per_org_structure_elements
5573: where organization_id_child = c_org_id
5574: AND org_structure_version_id = c_version_id
5575: AND business_group_id = p_business_group_id;
5576:

Line 5781: from per_org_structure_elements

5777: CURSOR c_find_parent_id(c_org_id in number
5778: ,c_version_id in number
5779: ,c_bgid in number) IS
5780: select organization_id_parent
5781: from per_org_structure_elements
5782: where organization_id_child = c_org_id
5783: AND org_structure_version_id = c_version_id
5784: AND business_group_id = c_bgid;
5785:

Line 6489: from per_org_structure_elements

6485: --Cursor to find the parent id from the org id
6486: CURSOR c_find_parent_id(c_org_id in number
6487: ,c_version_id in number) IS
6488: select organization_id_parent
6489: from per_org_structure_elements
6490: where organization_id_child = c_org_id
6491: AND org_structure_version_id = c_version_id
6492: AND business_group_id = p_business_group_id;
6493: