DBA Data[Home] [Help]

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