APPS.IBY_PAYGROUP_PUB dependencies on IBY_PAYMENT_METHODS_B

Line 747: FROM iby_payment_methods_b

743: */
744: BEGIN
745: SELECT nvl(anticipated_float,0) + IBY_PAYGROUP_PUB.pmtTable.maturity_date(p_trx_pmt_line_index)
746: INTO l_antcptd_val_date
747: FROM iby_payment_methods_b
748: WHERE payment_method_code = IBY_PAYGROUP_PUB.pmtTable.payment_method_code(p_trx_pmt_line_index);
749: EXCEPTION
750: WHEN OTHERS THEN
751: --If no value is found then anticipated value date is not set.

Line 788: FROM iby_payment_methods_b

784: */
785: BEGIN
786: SELECT nvl(anticipated_float,0) + IBY_PAYGROUP_PUB.pmtTable.payment_date(p_trx_pmt_line_index)
787: INTO l_antcptd_val_date
788: FROM iby_payment_methods_b
789: WHERE payment_method_code = IBY_PAYGROUP_PUB.pmtTable.payment_method_code(p_trx_pmt_line_index);
790: EXCEPTION
791: WHEN OTHERS THEN
792: --If no value is found then anticipated value date is not set.

Line 827: FROM iby_payment_methods_b

823: --The Maturity date should exist.
824: BEGIN
825: SELECT nvl(anticipated_float,0) + IBY_PAYGROUP_PUB.pmtTable.maturity_date(p_trx_pmt_line_index)
826: INTO l_antcptd_val_date
827: FROM iby_payment_methods_b
828: WHERE payment_method_code = IBY_PAYGROUP_PUB.pmtTable.payment_method_code(p_trx_pmt_line_index);
829: EXCEPTION
830: WHEN OTHERS THEN
831: --If no value is found then anticipated value date is set to payment date.

Line 840: FROM iby_payment_methods_b

836: ELSE
837: BEGIN
838: SELECT nvl(anticipated_float,0) + IBY_PAYGROUP_PUB.pmtTable.payment_date(p_trx_pmt_line_index)
839: INTO l_antcptd_val_date
840: FROM iby_payment_methods_b
841: WHERE payment_method_code = IBY_PAYGROUP_PUB.pmtTable.payment_method_code(p_trx_pmt_line_index);
842: EXCEPTION
843: WHEN OTHERS THEN
844: --If no value is found then anticipated value date is set to payment date.

Line 1702: IBY_PAYMENT_METHODS_B pmt_mthd,

1698: IBY_PMT_CREATION_RULES pcr,
1699: IBY_PAYMENT_PROFILES ppf,
1700: IBY_PAY_SERVICE_REQUESTS prq,
1701: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1702: IBY_PAYMENT_METHODS_B pmt_mthd,
1703: CE_BANK_ACCOUNTS iba
1704: WHERE prq.payment_service_request_id = p_payment_request_id
1705: AND docs.payment_service_request_id = prq.payment_service_request_id
1706: AND docs.payment_profile_id = ppf.payment_profile_id

Line 3782: IBY_PAYMENT_METHODS_B pmt_mthd,

3778: IBY_PMT_CREATION_RULES pcr,
3779: IBY_PAYMENT_PROFILES ppf,
3780: IBY_PAY_SERVICE_REQUESTS prq,
3781: IBY_EXTERNAL_PAYEES_ALL ext_payee,
3782: IBY_PAYMENT_METHODS_B pmt_mthd,
3783: CE_BANK_ACCOUNTS iba
3784: WHERE prq.payment_service_request_id = p_payment_request_id
3785: AND docs.payment_service_request_id = prq.payment_service_request_id
3786: AND docs.payment_profile_id = ppf.payment_profile_id