APPS.PQH_PQUBGTEN_XMLP_PKG dependencies on PER_ORGANIZATION_STRUCTURES

Line 21: FROM per_organization_structures

17: Select trunc(sysdate)
18: From dual;
19: cursor csr_org_struct_name IS
20: SELECT name
21: FROM per_organization_structures
22: WHERE organization_structure_id = p_org_structure_id;
23: l_org_struct_name per_organization_structures.name%TYPE;
24: Cursor Csr_entity_name IS
25: SELECT meaning

Line 23: l_org_struct_name per_organization_structures.name%TYPE;

19: cursor csr_org_struct_name IS
20: SELECT name
21: FROM per_organization_structures
22: WHERE organization_structure_id = p_org_structure_id;
23: l_org_struct_name per_organization_structures.name%TYPE;
24: Cursor Csr_entity_name IS
25: SELECT meaning
26: FROM hr_lookups
27: WHERE lookup_type IN ('PQH_BUDGET_ENTITY','UNDER_BDGT_EXTRA_TYPES')