APPS.RLM_FORECAST_SV dependencies on HZ_CUST_ACCT_SITES

Line 1495: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

1491: --
1492: -- Following query is changed as per TCA obsolescence project.
1493: SELECT CUST_SITE.CUST_ACCT_SITE_ID
1494: INTO v_bill_address_Id
1495: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1496: HZ_CUST_SITE_USES_ALL CUST_SITE
1497: WHERE CUST_SITE.site_use_id = x_bill_site_id
1498: AND CUST_SITE.site_use_code = 'BILL_TO'
1499: AND CUST_SITE.status = 'A'

Line 1515: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

1511: --
1512: -- Following query is changed as per TCA obsolescence project.
1513: SELECT CUST_SITE.SITE_USE_ID
1514: INTO v_bill_site_id
1515: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1516: HZ_CUST_SITE_USES_ALL CUST_SITE
1517: WHERE CUST_SITE.CUST_ACCT_SITE_ID = x_bill_address_id
1518: AND CUST_SITE.site_use_code = 'BILL_TO'
1519: AND CUST_SITE.status = 'A'

Line 1991: HZ_CUST_ACCT_SITES ACCT_SITE

1987: SELECT ETG.TP_GROUP_CODE
1988: INTO x_tp_group_code
1989: FROM ECE_TP_GROUP ETG,
1990: ECE_TP_HEADERS ETH,
1991: HZ_CUST_ACCT_SITES ACCT_SITE
1992: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
1993: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
1994: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID
1995: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_Sched_rec.ECE_TP_LOCATION_CODE_EXT;

Line 2006: FROM HZ_CUST_ACCT_SITES ACCT_SITE

2002: --
2003: -- Following query is changed as per TCA obsolescence project.
2004: SELECT ece_tp_location_code
2005: INTO x_ship_to_ece_locn_code
2006: FROM HZ_CUST_ACCT_SITES ACCT_SITE
2007: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
2008: --
2009: EXCEPTION
2010: WHEN NO_DATA_FOUND THEN