DBA Data[Home] [Help]

APPS.PER_NL_LTSRR_ARCHIVE dependencies on PER_ORGANIZATION_STRUCTURES

Line 1675: FROM per_organization_structures

1671: l_lang VARCHAR2(2) := userenv('lang');
1672:
1673: CURSOR c_get_hierarchy(p_org_struct_id IN NUMBER) IS
1674: SELECT name
1675: FROM per_organization_structures
1676: WHERE organization_structure_id = p_org_struct_id;
1677:
1678: CURSOR c_get_employer(p_org_id IN NUMBER) IS
1679: SELECT name