APPS.RLM_RLMDMSIQ_XMLP_PKG dependencies on HZ_CUST_SITE_USES

Line 12: HZ_CUST_SITE_USES_ALL CUST_SITE,

8: CURSOR CUR_P_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
9: SELECT
10: ACCT_SITE.ECE_TP_LOCATION_CODE
11: FROM
12: HZ_CUST_SITE_USES_ALL CUST_SITE,
13: HZ_CUST_ACCT_SITES ACCT_SITE
14: WHERE CUST_SITE.SITE_USE_CODE = L_SHIP_TO
15: AND ACCT_SITE.STATUS = L_STATUS
16: AND CUST_SITE.SITE_USE_ID = NU_SHIP_TO

Line 231: HZ_CUST_SITE_USES

227: SELECT
228: LOCATION
229: INTO V_VALUE
230: FROM
231: HZ_CUST_SITE_USES
232: WHERE SITE_USE_CODE = 'SHIP_TO'
233: AND SITE_USE_ID = SHIP_TO_ORG_ID3;
234: RETURN (V_VALUE);
235: EXCEPTION

Line 248: HZ_CUST_SITE_USES

244: SELECT
245: LOCATION
246: INTO V_VALUE
247: FROM
248: HZ_CUST_SITE_USES
249: WHERE SITE_USE_CODE = 'SHIP_TO'
250: AND SITE_USE_ID = INTMED_SHIP_TO_ORG_ID;
251: RETURN (V_VALUE);
252: END IF;

Line 266: HZ_CUST_SITE_USES_ALL CUST_SITE,

262: SELECT
263: LOC.ADDRESS1
264: INTO V_VALUE
265: FROM
266: HZ_CUST_SITE_USES_ALL CUST_SITE,
267: HZ_PARTY_SITES PARTY_SITE,
268: HZ_LOCATIONS LOC,
269: HZ_CUST_ACCT_SITES ACCT_SITE
270: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'

Line 291: HZ_CUST_SITE_USES_ALL CUST_SITE,

287: SELECT
288: LOC.ADDRESS1
289: INTO V_VALUE
290: FROM
291: HZ_CUST_SITE_USES_ALL CUST_SITE,
292: HZ_PARTY_SITES PARTY_SITE,
293: HZ_LOCATIONS LOC,
294: HZ_CUST_ACCT_SITES ACCT_SITE
295: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'