DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_PMT_MTHD_ATTRIB_APPL

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 469: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,

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
473: WHERE (pc.payment_channel_code = ci_pmt_channel)

Line 470: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,

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
473: WHERE (pc.payment_channel_code = ci_pmt_channel)
474: -- instrument security

Line 471: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,

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
473: WHERE (pc.payment_channel_code = ci_pmt_channel)
474: -- instrument security
475: AND (pc.payment_channel_code = isec.payment_method_code(+))

Line 472: iby_pmt_mthd_attrib_appl addinfo

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
473: WHERE (pc.payment_channel_code = ci_pmt_channel)
474: -- instrument security
475: AND (pc.payment_channel_code = isec.payment_method_code(+))
476: AND (isec.payment_flow(+) = 'FUNDS_CAPTURE')