APPS.RLM_RLMSCHRL_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES

Line 51: HZ_CUST_ACCT_SITES

47: SELECT
48: ECE_TP_LOCATION_CODE
49: INTO LCODE
50: FROM
51: HZ_CUST_ACCT_SITES
52: WHERE CUST_ACCT_SITE_ID = SHIP_TO_ADDRESS_ID;
53: ELSE
54: LCODE := CUST_SHIP_TO_EXT;
55: END IF;

Line 307: HZ_CUST_ACCT_SITES

303: SELECT
304: ECE_TP_LOCATION_CODE
305: INTO LCODE
306: FROM
307: HZ_CUST_ACCT_SITES
308: WHERE CUST_ACCT_SITE_ID = P_SHIP_TO;
309: CP_SHIP_TO := LCODE;
310: ELSE
311: CP_SHIP_TO := P_SHIP_TO;

Line 457: HZ_CUST_ACCT_SITES

453: SELECT
454: ECE_TP_LOCATION_CODE
455: INTO LCODE
456: FROM
457: HZ_CUST_ACCT_SITES
458: WHERE CUST_ACCT_SITE_ID = SHIP_TO_ADDRESS_ID1;
459: ELSE
460: LCODE := CUST_SHIP_TO_EXT1;
461: END IF;

Line 530: HZ_CUST_ACCT_SITES

526: SELECT
527: ECE_TP_LOCATION_CODE
528: INTO LCODE
529: FROM
530: HZ_CUST_ACCT_SITES
531: WHERE CUST_ACCT_SITE_ID = BILL_TO_ADDRESS_ID;
532: RETURN (LCODE);
533: EXCEPTION
534: WHEN OTHERS THEN

Line 545: HZ_CUST_ACCT_SITES

541: SELECT
542: ECE_TP_LOCATION_CODE
543: INTO LCODE
544: FROM
545: HZ_CUST_ACCT_SITES
546: WHERE CUST_ACCT_SITE_ID = BILL_TO_ADDRESS_ID1;
547: RETURN (LCODE);
548: EXCEPTION
549: WHEN OTHERS THEN