APPS.RLM_RD_SV dependencies on HZ_CUST_ACCT_SITES

Line 12442: HZ_CUST_ACCT_SITES ACCT_SITE

12438: SELECT ETG.TP_GROUP_CODE
12439: INTO x_tp_group_code
12440: FROM ECE_TP_GROUP ETG,
12441: ECE_TP_HEADERS ETH,
12442: HZ_CUST_ACCT_SITES ACCT_SITE
12443: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
12444: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
12445: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID
12446: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_Sched_rec.ECE_TP_LOCATION_CODE_EXT;

Line 12457: FROM HZ_CUST_ACCT_SITES ACCT_SITE

12453: --
12454: -- Following query is changed as per TCA obsolescence project.
12455: SELECT ece_tp_location_code
12456: INTO x_ship_to_ece_locn_code
12457: FROM HZ_CUST_ACCT_SITES ACCT_SITE
12458: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
12459: --
12460: EXCEPTION
12461: WHEN NO_DATA_FOUND THEN

Line 12513: HZ_CUST_ACCT_SITES ACCT_SITE

12509: SELECT ETG.TP_GROUP_CODE
12510: INTO x_tp_group_code
12511: FROM ECE_TP_GROUP ETG,
12512: ECE_TP_HEADERS ETH,
12513: HZ_CUST_ACCT_SITES ACCT_SITE
12514: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
12515: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
12516: and ACCT_SITE.ECE_TP_LOCATION_CODE = v_ECE_TP_LOCATION_CODE_EXT ;
12517: ELSE

Line 12526: FROM HZ_CUST_ACCT_SITES

12522: --
12523: -- Following query is changed as per TCA obsolescence project.
12524: SELECT ece_tp_location_code
12525: INTO x_ship_to_ece_locn_code
12526: FROM HZ_CUST_ACCT_SITES
12527: WHERE CUST_ACCT_SITE_ID = x_key_rec.req_rec.ship_to_address_id;
12528: --
12529: EXCEPTION
12530: WHEN NO_DATA_FOUND THEN

Line 12565: FROM HZ_CUST_ACCT_SITES

12561: --
12562: -- Following query is changed as per TCA obsolescence project.
12563: SELECT ece_tp_location_code
12564: INTO x_ship_to_ece_locn_code
12565: FROM HZ_CUST_ACCT_SITES
12566: WHERE CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
12567: --
12568: EXCEPTION
12569: WHEN NO_DATA_FOUND THEN