APPS.RLM_BLANKET_SV dependencies on HZ_CUST_ACCT_SITES

Line 1048: HZ_CUST_ACCT_SITES ACCT_SITE

1044: SELECT ETG.TP_GROUP_CODE
1045: INTO x_tp_group_code
1046: FROM ECE_TP_GROUP ETG,
1047: ECE_TP_HEADERS ETH,
1048: HZ_CUST_ACCT_SITES ACCT_SITE
1049: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
1050: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
1051: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID
1052: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_Sched_rec.ECE_TP_LOCATION_CODE_EXT;

Line 1063: FROM HZ_CUST_ACCT_SITES

1059: --
1060: -- Following query is changed as per TCA obsolescence project.
1061: SELECT ece_tp_location_code
1062: INTO x_ship_to_ece_locn_code
1063: FROM HZ_CUST_ACCT_SITES
1064: WHERE CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
1065: --
1066: EXCEPTION
1067: WHEN NO_DATA_FOUND THEN