DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_PMT_MTHD_ATTRIB_APPL

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

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

Line 560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,

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

Line 561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,

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
563: WHERE (pc.payment_channel_code = ci_pmt_channel)
564: -- instrument security
565: AND (pc.payment_channel_code = isec.payment_method_code(+))

Line 562: iby_pmt_mthd_attrib_appl addinfo

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
563: WHERE (pc.payment_channel_code = ci_pmt_channel)
564: -- instrument security
565: AND (pc.payment_channel_code = isec.payment_method_code(+))
566: AND (isec.payment_flow(+) = 'FUNDS_CAPTURE')