APPS.JA_JAINARE1_XMLP_PKG dependencies on HR_LOCATIONS

Line 8: HR_LOCATIONS

4: CURSOR C_CITY(P_LOCATION_ID IN NUMBER) IS
5: SELECT
6: TOWN_OR_CITY
7: FROM
8: HR_LOCATIONS
9: WHERE LOCATION_ID = P_LOCATION_ID;
10: CURSOR C_LOCATION(P_ORGANIZATION_ID IN NUMBER) IS
11: SELECT
12: LOCATION_ID

Line 24: V_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

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
28: INTO V_ORGANIZATION_ID;