APPS.OE_PAYMENT_TRXN_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 187: From HZ_CUST_SITE_USES_ALL SITE,

183:
184: BEGIN
185: Select hca.party_id, acct_site.cust_account_id,acct_site.party_site_id
186: Into l_party_id, l_cust_account_id,l_party_site_id
187: From HZ_CUST_SITE_USES_ALL SITE,
188: HZ_CUST_ACCT_SITES ACCT_SITE,
189: HZ_CUST_ACCOUNTS_ALL HCA
190: Where SITE.SITE_USE_ID = p_site_use_id
191: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 911: From HZ_CUST_SITE_USES_ALL SITE,

907:
908: Begin
909: Select hca.party_id, acct_site.cust_account_id,acct_site.party_site_id
910: Into l_party_id, l_cust_account_id,l_party_site_id
911: From HZ_CUST_SITE_USES_ALL SITE,
912: HZ_CUST_ACCT_SITES ACCT_SITE,
913: HZ_CUST_ACCOUNTS_ALL HCA
914: Where SITE.SITE_USE_ID = p_site_use_id
915: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 1937: From HZ_CUST_SITE_USES_ALL SITE,

1933:
1934: Begin
1935: Select hca.party_id, acct_site.cust_account_id
1936: Into l_party_id, l_cust_account_id
1937: From HZ_CUST_SITE_USES_ALL SITE,
1938: HZ_CUST_ACCT_SITES ACCT_SITE,
1939: HZ_CUST_ACCOUNTS_ALL HCA
1940: Where SITE.SITE_USE_ID = p_site_use_id
1941: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 2563: From HZ_CUST_SITE_USES_ALL SITE,

2559: END IF;
2560:
2561: Select hca.party_id, acct_site.cust_account_id
2562: Into l_party_id, l_cust_account_id
2563: From HZ_CUST_SITE_USES_ALL SITE,
2564: HZ_CUST_ACCT_SITES ACCT_SITE,
2565: HZ_CUST_ACCOUNTS_ALL HCA
2566: Where SITE.SITE_USE_ID = l_site_use_id
2567: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 2977: FROM hz_cust_acct_sites_all acctsite, hz_cust_site_uses_all site, hz_cust_accounts_all hca

2973:
2974: Begin
2975: SELECT hca.party_id,acctsite.cust_account_id
2976: INTO l_party_id, l_cust_account_id
2977: FROM hz_cust_acct_sites_all acctsite, hz_cust_site_uses_all site, hz_cust_accounts_all hca
2978: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
2979: AND SITE.CUST_ACCT_SITE_ID = ACCTSITE.CUST_ACCT_SITE_ID
2980: AND ACCTSITE.cust_account_id = HCA.cust_account_id
2981: AND SITE.SITE_USE_ID = l_invoice_to_org_id;