APPS.JA_JAINARE1_XMLP_PKG dependencies on HZ_LOCATIONS

Line 79: HZ_LOCATIONS HZL,

75: CURSOR C_COUNTRY(P_ADDRESS_ID IN NUMBER) IS
76: SELECT
77: HZL.COUNTRY COUNTRY
78: FROM
79: HZ_LOCATIONS HZL,
80: HZ_PARTY_SITES HZPS,
81: HZ_CUST_ACCT_SITES_ALL HZCAS
82: WHERE HZL.LOCATION_ID = HZPS.LOCATION_ID
83: AND HZPS.PARTY_SITE_ID = HZCAS.PARTY_SITE_ID

Line 86: V_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;

82: WHERE HZL.LOCATION_ID = HZPS.LOCATION_ID
83: AND HZPS.PARTY_SITE_ID = HZCAS.PARTY_SITE_ID
84: AND HZCAS.CUST_ACCT_SITE_ID = P_ADDRESS_ID;
85: V_ADDRESS_ID HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
86: V_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;
87: BEGIN
88: OPEN C_ADDRESS(SHIP_TO_SITE_USE_ID);
89: FETCH C_ADDRESS
90: INTO V_ADDRESS_ID;