DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on HZ_PARTY_PREFERENCES

Line 1189: hz_party_preferences pp1,

1185: bank.bank_id bank_party_id,
1186: bank.branch_id branch_party_id,
1187: bank.object_version_number
1188: FROM hz_cust_accounts cust,
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,

Line 1239: hz_party_preferences pp1,

1235: NULL bank_party_id,
1236: NULL branch_party_id,
1237: NULL object_version_number
1238: FROM hz_cust_accounts cust,
1239: hz_party_preferences pp1,
1240: iby_external_payers_all p,
1241: iby_pmt_instr_uses_all u,
1242: iby_creditcard c,
1243: iby_creditcard_issuers_vl i,

Line 1708: FROM hz_party_preferences

1704: WHERE cust_account_id = p_customer_id;
1705:
1706: CURSOR object_version_cur(p_party_id IN NUMBER, p_preference_code IN VARCHAR2) IS
1707: SELECT party_preference_id, object_version_number
1708: FROM hz_party_preferences
1709: WHERE party_id = p_party_id
1710: AND category = 'LAST_USED_PAYMENT_INSTRUMENT'
1711: AND preference_code = p_preference_code;
1712: