APPS.AR_IREC_PAYMENTS dependencies on IBY_PMT_INSTR_USES_ALL

Line 1262: iby_pmt_instr_uses_all u,

1258: bank.object_version_number
1259: FROM hz_cust_accounts cust,
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

Line 1364: iby_pmt_instr_uses_all u,

1360: bank.object_version_number
1361: FROM
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

Line 1420: iby_pmt_instr_uses_all u,

1416: fnd_lookup_values_vl ccunk,
1417: iby_creditcard c,
1418: iby_creditcard_issuers_vl i,
1419: iby_external_payers_all p,
1420: iby_pmt_instr_uses_all u,
1421: hz_parties hzcc,
1422: hz_cust_accounts cust,
1423: hz_party_site_uses psu,
1424: hz_party_sites hps,

Line 2967: select INSTRUMENT_PAYMENT_USE_ID,ORDER_OF_PREFERENCE,START_DATE from IBY_PMT_INSTR_USES_ALL

2963: FROM ce_bank_branches_V
2964: WHERE upper(bank_name) = upper(l_bank_name);
2965:
2966: CURSOR chk_instr_assigned_cur(l_bank_account_id NUMBER, p_customer_id NUMBER, p_customer_site_id NUMBER) IS
2967: select INSTRUMENT_PAYMENT_USE_ID,ORDER_OF_PREFERENCE,START_DATE from IBY_PMT_INSTR_USES_ALL
2968: where instrument_id = l_bank_account_id
2969: and EXT_PMT_PARTY_ID = (select EXT_PAYER_ID from IBY_EXTERNAL_PAYERS_ALL
2970: where CUST_ACCOUNT_ID = p_customer_id
2971: and ACCT_SITE_USE_ID = p_customer_site_id);

Line 2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;

2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;
2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;
2992: l_branch_id ce_bank_branches_v.branch_party_id%TYPE;
2993:

Line 2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;

2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;
2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;
2992: l_branch_id ce_bank_branches_v.branch_party_id%TYPE;
2993:
2994: bank_branch_rec bank_branch_cur%ROWTYPE;