APPS.JA_JAINARE1_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 14: HR_ORGANIZATION_UNITS

10: CURSOR C_LOCATION(P_ORGANIZATION_ID IN NUMBER) IS
11: SELECT
12: LOCATION_ID
13: FROM
14: HR_ORGANIZATION_UNITS
15: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
16: CURSOR C_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER) IS
17: SELECT
18: LEGAL_ENTITY

Line 23: V_LOCATION_ID HR_ORGANIZATION_UNITS.LOCATION_ID%TYPE;

19: FROM
20: ORG_ORGANIZATION_DEFINITIONS
21: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
22: V_ORGANIZATION_ID ORG_ORGANIZATION_DEFINITIONS.LEGAL_ENTITY%TYPE;
23: V_LOCATION_ID HR_ORGANIZATION_UNITS.LOCATION_ID%TYPE;
24: V_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
25: BEGIN
26: OPEN C_ORGANIZATION(P_ORGANIZATION_ID);
27: FETCH C_ORGANIZATION

Line 46: HR_ORGANIZATION_UNITS

42: CURSOR C_LEGAL_ENTITY_NAME(P_LEGAL_ENTITY_ID IN NUMBER) IS
43: SELECT
44: NAME
45: FROM
46: HR_ORGANIZATION_UNITS
47: WHERE ORGANIZATION_ID = P_LEGAL_ENTITY_ID;
48: CURSOR C_LEGAL_ENTITY_ID(P_ORGANIZATION_ID IN NUMBER) IS
49: SELECT
50: LEGAL_ENTITY