APPS.OE_PAYMENT_TRXN_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 130: HZ_CUST_ACCT_SITES ACCT_SITE,

126: BEGIN
127: Select hca.party_id, acct_site.cust_account_id,acct_site.party_site_id
128: Into l_party_id, l_cust_account_id,l_party_site_id
129: From HZ_CUST_SITE_USES_ALL SITE,
130: HZ_CUST_ACCT_SITES ACCT_SITE,
131: HZ_CUST_ACCOUNTS_ALL HCA
132: Where SITE.SITE_USE_ID = p_site_use_id
133: AND SITE.SITE_USE_CODE = 'BILL_TO'
134: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 771: HZ_CUST_ACCT_SITES ACCT_SITE,

767: Begin
768: Select hca.party_id, acct_site.cust_account_id,acct_site.party_site_id
769: Into l_party_id, l_cust_account_id,l_party_site_id
770: From HZ_CUST_SITE_USES_ALL SITE,
771: HZ_CUST_ACCT_SITES ACCT_SITE,
772: HZ_CUST_ACCOUNTS_ALL HCA
773: Where SITE.SITE_USE_ID = p_site_use_id
774: AND SITE.SITE_USE_CODE = 'BILL_TO'
775: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1635: HZ_CUST_ACCT_SITES ACCT_SITE,

1631: Begin
1632: Select hca.party_id, acct_site.cust_account_id
1633: Into l_party_id, l_cust_account_id
1634: From HZ_CUST_SITE_USES_ALL SITE,
1635: HZ_CUST_ACCT_SITES ACCT_SITE,
1636: HZ_CUST_ACCOUNTS_ALL HCA
1637: Where SITE.SITE_USE_ID = p_site_use_id
1638: AND SITE.SITE_USE_CODE = 'BILL_TO'
1639: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 2168: HZ_CUST_ACCT_SITES ACCT_SITE,

2164:
2165: Select hca.party_id, acct_site.cust_account_id
2166: Into l_party_id, l_cust_account_id
2167: From HZ_CUST_SITE_USES_ALL SITE,
2168: HZ_CUST_ACCT_SITES ACCT_SITE,
2169: HZ_CUST_ACCOUNTS_ALL HCA
2170: Where SITE.SITE_USE_ID = l_site_use_id
2171: AND SITE.SITE_USE_CODE = 'BILL_TO'
2172: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID