APPS.IEX_UTILITIES dependencies on HZ_CUST_SITE_USES

Line 1531: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca

1527: l_delinquency_id number;
1528:
1529: CURSOR get_party_account_id_cur (p_customer_site_use_id number) is
1530: SELECT ca.party_id party_id, ca.cust_account_id cust_account_id
1531: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca
1532: WHERE site_uses.site_use_id = p_customer_site_use_id
1533: AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id
1534: AND ca.cust_account_id = acct_sites.cust_account_id;
1535:

Line 4140: select site_use_code into tt_code from hz_cust_site_uses_all where site_use_id = l_site_use_id;

4136:
4137: -- Bills Receivables bug 16303059 begin....
4138: begin
4139: tt_site_use_id := 0;
4140: select site_use_code into tt_code from hz_cust_site_uses_all where site_use_id = l_site_use_id;
4141:
4142: if tt_code = 'BILL_TO' then
4143: tt_site_use_id := get_BR_DrweeSiteID(l_site_use_id); -- Bills Receivables
4144:

Line 5746: select site_use_code from hz_cust_site_uses where site_use_id = p_site_use_id;

5742:
5743: Function get_BR_BillTOID (p_id in number)return number is
5744:
5745: cursor c_code(p_site_use_id number) is
5746: select site_use_code from hz_cust_site_uses where site_use_id = p_site_use_id;
5747:
5748: cursor c_id(p_site_use_id number) is
5749: select site_use_id from hz_cust_site_uses where site_use_code = 'BILL_TO'
5750: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)

Line 5749: select site_use_id from hz_cust_site_uses where site_use_code = 'BILL_TO'

5745: cursor c_code(p_site_use_id number) is
5746: select site_use_code from hz_cust_site_uses where site_use_id = p_site_use_id;
5747:
5748: cursor c_id(p_site_use_id number) is
5749: select site_use_id from hz_cust_site_uses where site_use_code = 'BILL_TO'
5750: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)
5751: and status = 'A';
5752:
5753: x_id number;

Line 5750: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)

5746: select site_use_code from hz_cust_site_uses where site_use_id = p_site_use_id;
5747:
5748: cursor c_id(p_site_use_id number) is
5749: select site_use_id from hz_cust_site_uses where site_use_code = 'BILL_TO'
5750: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)
5751: and status = 'A';
5752:
5753: x_id number;
5754: x_code varchar2(30);

Line 5778: select site_use_id from hz_cust_site_uses where site_use_code = 'DRAWEE'

5774:
5775: Function get_BR_DrweeSiteID (p_id in number)return number is
5776:
5777: cursor c_id(p_site_use_id number) is
5778: select site_use_id from hz_cust_site_uses where site_use_code = 'DRAWEE'
5779: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)
5780: and status = 'A';
5781:
5782: x_id number;

Line 5779: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)

5775: Function get_BR_DrweeSiteID (p_id in number)return number is
5776:
5777: cursor c_id(p_site_use_id number) is
5778: select site_use_id from hz_cust_site_uses where site_use_code = 'DRAWEE'
5779: and cust_acct_site_id = (select cs.cust_acct_site_id from hz_cust_site_uses cs where cs.site_use_id = p_site_use_id)
5780: and status = 'A';
5781:
5782: x_id number;
5783: x_code varchar2(30);