APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_PMT_MTHD_ATTRIB_APPL

Line 777: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE

773: END Payer_Channel_Valid;
774:
775: FUNCTION Channel_InstrAssignment_Appl
776: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
777: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE
778: IS
779: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
780:
781: CURSOR c_pmt_instr

Line 779: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;

775: FUNCTION Channel_InstrAssignment_Appl
776: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
777: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE
778: IS
779: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
780:
781: CURSOR c_pmt_instr
782: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
783: IS

Line 785: FROM iby_pmt_mthd_attrib_appl

781: CURSOR c_pmt_instr
782: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
783: IS
784: SELECT attribute_applicability
785: FROM iby_pmt_mthd_attrib_appl
786: WHERE (payment_flow = 'FUNDS_CAPTURE')
787: AND (payment_method_code = ci_pmt_channel)
788: AND (attribute_code = 'PAYMENT_INSTRUMENT');
789:

Line 820: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;

816: )
817: RETURN BOOLEAN
818: IS
819: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
820: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
821:
822: -- cursor def changes for bug 5117954
823: CURSOR c_channel_assign
824: (ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,

Line 882: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;

878: )
879: RETURN BOOLEAN
880: IS
881: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
882: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
883: l_instr_type iby_fndcpt_payer_assgn_instr_v.instrument_type%TYPE;
884: l_instr_id iby_fndcpt_payer_assgn_instr_v.instrument_id%TYPE;
885: l_info_only iby_fndcpt_payer_assgn_instr_v.card_info_only_flag%TYPE;
886: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;