APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 46: FROM iby_external_payers_all payer,hz_cust_accounts acct, hz_cust_acct_sites_all hzcustacct, HZ_CUST_SITE_USES_ALL siteuses

42: p_payer_org_type VARCHAR2)
43: IS
44: SELECT payer.DEBIT_ADVICE_DELIVERY_METHOD,
45: payer.DEBIT_ADVICE_EMAIL, payer.DEBIT_ADVICE_FAX
46: FROM iby_external_payers_all payer,hz_cust_accounts acct, hz_cust_acct_sites_all hzcustacct, HZ_CUST_SITE_USES_ALL siteuses
47: WHERE payer.PARTY_ID = p_payee_party_id
48: AND nvl(payer.ORG_ID,-1) = nvl(p_payer_org_id,-1)
49: AND nvl(payer.ORG_TYPE,-1) = nvl(p_payer_org_type,-1)
50: AND nvl(payer.acct_site_use_id,-1) = nvl(siteuses.site_use_id,-1)