APPS.AR_IREC_PAYMENTS dependencies on HZ_ORGANIZATION_PROFILES

Line 1264: hz_organization_profiles bapr,

1260: hz_party_preferences pp1,
1261: iby_external_payers_all p,
1262: iby_pmt_instr_uses_all u,
1263: iby_ext_bank_accounts bank,
1264: hz_organization_profiles bapr,
1265: hz_organization_profiles brpr,
1266: iby_account_owners ow
1267: WHERE cust.cust_account_id = p_customer_id
1268: AND pp1.party_id = cust.party_id

Line 1265: hz_organization_profiles brpr,

1261: iby_external_payers_all p,
1262: iby_pmt_instr_uses_all u,
1263: iby_ext_bank_accounts bank,
1264: hz_organization_profiles bapr,
1265: hz_organization_profiles brpr,
1266: iby_account_owners ow
1267: WHERE cust.cust_account_id = p_customer_id
1268: AND pp1.party_id = cust.party_id
1269: AND pp1.category = 'LAST_USED_PAYMENT_INSTRUMENT'

Line 1366: hz_organization_profiles bapr,

1362: hz_cust_accounts cust,
1363: iby_external_payers_all p,
1364: iby_pmt_instr_uses_all u,
1365: iby_ext_bank_accounts bank,
1366: hz_organization_profiles bapr,
1367: hz_organization_profiles brpr,
1368: iby_account_owners ow
1369:
1370: WHERE

Line 1367: hz_organization_profiles brpr,

1363: iby_external_payers_all p,
1364: iby_pmt_instr_uses_all u,
1365: iby_ext_bank_accounts bank,
1366: hz_organization_profiles bapr,
1367: hz_organization_profiles brpr,
1368: iby_account_owners ow
1369:
1370: WHERE
1371: cust.cust_account_id = p_customer_id

Line 5002: hz_organization_profiles pr

4998: from ar_cash_receipts_all cr,
4999: ce_bank_acct_uses bau,
5000: ce_bank_accounts cba,
5001: hz_parties bank,
5002: hz_organization_profiles pr
5003: where cr.cash_receipt_id = p_cash_receipt_id
5004: AND cr.remit_bank_acct_use_id = bau.bank_acct_use_id
5005: AND bau.bank_account_id = cba.bank_account_id
5006: AND cba.bank_id = bank.party_id