APPS.RLM_RD_SV dependencies on HZ_CUST_ACCT_SITES

Line 12636: HZ_CUST_ACCT_SITES ACCT_SITE

12632: SELECT ETG.TP_GROUP_CODE
12633: INTO x_tp_group_code
12634: FROM ECE_TP_GROUP ETG,
12635: ECE_TP_HEADERS ETH,
12636: HZ_CUST_ACCT_SITES ACCT_SITE
12637: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
12638: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
12639: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID
12640: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_Sched_rec.ECE_TP_LOCATION_CODE_EXT;

Line 12651: FROM HZ_CUST_ACCT_SITES ACCT_SITE

12647: --
12648: -- Following query is changed as per TCA obsolescence project.
12649: SELECT ece_tp_location_code
12650: INTO x_ship_to_ece_locn_code
12651: FROM HZ_CUST_ACCT_SITES ACCT_SITE
12652: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
12653: --
12654: EXCEPTION
12655: WHEN NO_DATA_FOUND THEN

Line 12707: HZ_CUST_ACCT_SITES ACCT_SITE

12703: SELECT ETG.TP_GROUP_CODE
12704: INTO x_tp_group_code
12705: FROM ECE_TP_GROUP ETG,
12706: ECE_TP_HEADERS ETH,
12707: HZ_CUST_ACCT_SITES ACCT_SITE
12708: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
12709: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
12710: and ACCT_SITE.ECE_TP_LOCATION_CODE = v_ECE_TP_LOCATION_CODE_EXT ;
12711: ELSE

Line 12720: FROM HZ_CUST_ACCT_SITES

12716: --
12717: -- Following query is changed as per TCA obsolescence project.
12718: SELECT ece_tp_location_code
12719: INTO x_ship_to_ece_locn_code
12720: FROM HZ_CUST_ACCT_SITES
12721: WHERE CUST_ACCT_SITE_ID = x_key_rec.req_rec.ship_to_address_id;
12722: --
12723: EXCEPTION
12724: WHEN NO_DATA_FOUND THEN

Line 12759: FROM HZ_CUST_ACCT_SITES

12755: --
12756: -- Following query is changed as per TCA obsolescence project.
12757: SELECT ece_tp_location_code
12758: INTO x_ship_to_ece_locn_code
12759: FROM HZ_CUST_ACCT_SITES
12760: WHERE CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
12761: --
12762: EXCEPTION
12763: WHEN NO_DATA_FOUND THEN