APPS.ASO_PAYMENT_INT dependencies on IBY_TRXN_EXTENSIONS_V

Line 704: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b

700: /*** Commented this for Bug 9751000 ***/
701: /*
702: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
703: select a.party_id
704: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
705: where a.instr_assignment_id = b.instr_assignment_id
706: and b.trxn_extension_id = p_trxn_extension_id;
707: */
708:

Line 721: IBY_TRXN_EXTENSIONS_V t

717: iby_external_payers_all p,
718: iby_ext_bank_accounts_v b,
719: iby_pmt_instr_uses_all u,
720: hz_parties hzcc,
721: IBY_TRXN_EXTENSIONS_V t
722: WHERE(u.ext_pmt_party_id = p.ext_payer_id)
723: AND(decode(u.instrument_type, 'CREDITCARD', u.instrument_id, 'DEBITCARD', u.instrument_id, NULL) = c.instrid(+))
724: AND(decode(u.instrument_type, 'BANKACCOUNT', u.instrument_id, NULL) = b.bank_account_id(+))
725: AND(c.card_issuer_code = i.card_issuer_code(+))

Line 737: from IBY_TRXN_EXTENSIONS_V

733:
734: /*** Start : Code change done for Bug 14619666 ***/
735: Cursor c_check_authorized_flag(p_trxn_extension_id number) is
736: select authorized_flag
737: from IBY_TRXN_EXTENSIONS_V
738: where trxn_extension_id = p_trxn_extension_id;
739:
740: l_authorized_flag VARCHAR2(1);
741: /*** End : Code change done for Bug 14619666 ***/

Line 1601: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b

1597:
1598:
1599: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1600: select a.party_id
1601: from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
1602: where a.instr_assignment_id = b.instr_assignment_id
1603: and b.trxn_extension_id = p_trxn_extension_id;
1604:
1605: Begin