DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on HZ_ORGANIZATION_PROFILES

Line 1193: hz_organization_profiles bapr,

1189: hz_party_preferences pp1,
1190: iby_external_payers_all p,
1191: iby_pmt_instr_uses_all u,
1192: iby_ext_bank_accounts bank,
1193: hz_organization_profiles bapr,
1194: hz_organization_profiles brpr,
1195: iby_account_owners ow
1196: WHERE cust.cust_account_id = p_customer_id
1197: AND pp1.party_id = cust.party_id

Line 1194: hz_organization_profiles brpr,

1190: iby_external_payers_all p,
1191: iby_pmt_instr_uses_all u,
1192: iby_ext_bank_accounts bank,
1193: hz_organization_profiles bapr,
1194: hz_organization_profiles brpr,
1195: iby_account_owners ow
1196: WHERE cust.cust_account_id = p_customer_id
1197: AND pp1.party_id = cust.party_id
1198: AND pp1.category = 'LAST_USED_PAYMENT_INSTRUMENT'

Line 1298: hz_organization_profiles bapr,

1294: hz_cust_accounts cust,
1295: iby_external_payers_all p,
1296: iby_pmt_instr_uses_all u,
1297: iby_ext_bank_accounts bank,
1298: hz_organization_profiles bapr,
1299: hz_organization_profiles brpr,
1300: iby_account_owners ow
1301:
1302: WHERE

Line 1299: hz_organization_profiles brpr,

1295: iby_external_payers_all p,
1296: iby_pmt_instr_uses_all u,
1297: iby_ext_bank_accounts bank,
1298: hz_organization_profiles bapr,
1299: hz_organization_profiles brpr,
1300: iby_account_owners ow
1301:
1302: WHERE
1303: cust.cust_account_id = p_customer_id