APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_FNDCPT_PMT_CHNNLS_B

Line 105: CURSOR c_channel(ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

101: IS
102: l_code VARCHAR2(30);
103: l_exists BOOLEAN;
104:
105: CURSOR c_channel(ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
106: IS
107: SELECT payment_channel_code
108: FROM iby_fndcpt_pmt_chnnls_b
109: WHERE (payment_channel_code = ci_channel_code)

Line 108: FROM iby_fndcpt_pmt_chnnls_b

104:
105: CURSOR c_channel(ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
106: IS
107: SELECT payment_channel_code
108: FROM iby_fndcpt_pmt_chnnls_b
109: WHERE (payment_channel_code = ci_channel_code)
110: AND (NVL(inactive_date,SYSDATE-10) 111: BEGIN
112:

Line 548: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

544: l_module CONSTANT VARCHAR2(30) := 'Get_Payment_Channel_Attribs';
545: l_prev_msg_count NUMBER;
546:
547: CURSOR c_appl_attribs
548: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
549: IS
550: SELECT NVL(isec.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
551: NVL(ibill.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
552: NVL(vaflag.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),

Line 558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,

554: NVL(vadate.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
555: NVL(ponum.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
556: NVL(poline.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
557: NVL(addinfo.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL)
558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
559: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
562: iby_pmt_mthd_attrib_appl addinfo

Line 997: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c

993: ci_payer_level IN VARCHAR2,
994: ci_payer_equiv IN VARCHAR2)
995: IS
996: SELECT c.payment_channel_code, c.instrument_type
997: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
998: WHERE (pm.payment_method_code = c.payment_channel_code)
999: AND (NVL(pm.inactive_date,SYSDATE-10) 1000: AND (NVL(c.inactive_date,SYSDATE-10) 1001: AND (pm.payment_flow = G_PMT_FLOW_FNDCPT)