APPS.RLM_FORECAST_SV dependencies on HZ_CUST_ACCT_SITES

Line 1460: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

1456: --
1457: -- Following query is changed as per TCA obsolescence project.
1458: SELECT CUST_SITE.CUST_ACCT_SITE_ID
1459: INTO v_bill_address_Id
1460: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1461: HZ_CUST_SITE_USES_ALL CUST_SITE
1462: WHERE CUST_SITE.site_use_id = x_bill_site_id
1463: AND CUST_SITE.site_use_code = 'BILL_TO'
1464: AND CUST_SITE.status = 'A'

Line 1480: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

1476: --
1477: -- Following query is changed as per TCA obsolescence project.
1478: SELECT CUST_SITE.SITE_USE_ID
1479: INTO v_bill_site_id
1480: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1481: HZ_CUST_SITE_USES_ALL CUST_SITE
1482: WHERE CUST_SITE.CUST_ACCT_SITE_ID = x_bill_address_id
1483: AND CUST_SITE.site_use_code = 'BILL_TO'
1484: AND CUST_SITE.status = 'A'

Line 1956: HZ_CUST_ACCT_SITES ACCT_SITE

1952: SELECT ETG.TP_GROUP_CODE
1953: INTO x_tp_group_code
1954: FROM ECE_TP_GROUP ETG,
1955: ECE_TP_HEADERS ETH,
1956: HZ_CUST_ACCT_SITES ACCT_SITE
1957: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
1958: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
1959: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID
1960: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_Sched_rec.ECE_TP_LOCATION_CODE_EXT;

Line 1971: FROM HZ_CUST_ACCT_SITES ACCT_SITE

1967: --
1968: -- Following query is changed as per TCA obsolescence project.
1969: SELECT ece_tp_location_code
1970: INTO x_ship_to_ece_locn_code
1971: FROM HZ_CUST_ACCT_SITES ACCT_SITE
1972: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
1973: --
1974: EXCEPTION
1975: WHEN NO_DATA_FOUND THEN