APPS.PER_NL_DSRR_ARCHIVE dependencies on PER_ORGANIZATION_STRUCTURES
Line 1652: FROM per_organization_structures
1648: l_lang VARCHAR2(2) := userenv ('lang');
1649:
1650: CURSOR c_get_hierarchy(p_org_struct_id IN NUMBER) IS
1651: SELECT name 1652: FROM per_organization_structures 1653: WHERE organization_structure_id = p_org_struct_id;
1654:
1655: CURSOR c_get_employer(p_org_id IN NUMBER) IS
1656: SELECT name