APPS.JA_JAINAPCR_XMLP_PKG dependencies on HR_LOCATIONS

Line 48: HR_LOCATIONS

44: SELECT
45: INVENTORY_ORGANIZATION_ID
46: INTO V_ORGANIZATION_ID
47: FROM
48: HR_LOCATIONS
49: WHERE LOCATION_ID = V_SHIP_TO_LOCATION_ID;
50: SELECT
51: ORGANIZATION_NAME
52: INTO V_ORGANIZATION_NAME

Line 63: V_LOCATION_CODE HR_LOCATIONS.LOCATION_CODE%TYPE;

59: WHEN NO_DATA_FOUND THEN
60: RETURN NULL;
61: END CF_ORGNFORMULA;
62: FUNCTION CF_LOCNFORMULA(P_PO_DISTRIBUTION_ID IN NUMBER) RETURN VARCHAR2 IS
63: V_LOCATION_CODE HR_LOCATIONS.LOCATION_CODE%TYPE;
64: V_SHIP_TO_LOCATION_ID NUMBER;
65: V_LOCATION_ID NUMBER;
66: V_PO_HEADER_ID NUMBER;
67: CURSOR C_LOC_CODE IS

Line 71: HR_LOCATIONS HL,

67: CURSOR C_LOC_CODE IS
68: SELECT
69: LOCATION_CODE
70: FROM
71: HR_LOCATIONS HL,
72: PO_HEADERS_ALL PH,
73: PO_DISTRIBUTIONS_ALL POD
74: WHERE PH.PO_HEADER_ID = POD.PO_HEADER_ID
75: AND POD.PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID