DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_FNDCPT_PMT_CHNNLS_B

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

12: IS
13: l_code VARCHAR2(30);
14: l_exists BOOLEAN;
15:
16: CURSOR c_channel(ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
17: IS
18: SELECT payment_channel_code
19: FROM iby_fndcpt_pmt_chnnls_b
20: WHERE (payment_channel_code = ci_channel_code)

Line 19: FROM iby_fndcpt_pmt_chnnls_b

15:
16: CURSOR c_channel(ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
17: IS
18: SELECT payment_channel_code
19: FROM iby_fndcpt_pmt_chnnls_b
20: WHERE (payment_channel_code = ci_channel_code)
21: AND (NVL(inactive_date,SYSDATE-10) 22: BEGIN
23:

Line 458: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

454: l_module CONSTANT VARCHAR2(30) := 'Get_Payment_Channel_Attribs';
455: l_prev_msg_count NUMBER;
456:
457: CURSOR c_appl_attribs
458: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
459: IS
460: SELECT NVL(isec.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
461: NVL(ibill.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
462: NVL(vaflag.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),

Line 468: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,

464: NVL(vadate.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
465: NVL(ponum.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
466: NVL(poline.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
467: NVL(addinfo.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL)
468: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
469: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
470: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
471: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
472: iby_pmt_mthd_attrib_appl addinfo

Line 907: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c

903: ci_payer_level IN VARCHAR2,
904: ci_payer_equiv IN VARCHAR2)
905: IS
906: SELECT c.payment_channel_code, c.instrument_type
907: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
908: WHERE (pm.payment_method_code = c.payment_channel_code)
909: AND (NVL(pm.inactive_date,SYSDATE-10) 910: AND (NVL(c.inactive_date,SYSDATE-10) 911: AND (pm.payment_flow = G_PMT_FLOW_FNDCPT)