eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_APPLICABLE_PMT_MTHDS

Line 547: FROM IBY_APPLICABLE_PMT_MTHDS am,

543: am.PAYMENT_METHOD_CODE,
544: m.SUPPORT_BILLS_PAYABLE_FLAG,
545: m.MATURITY_DATE_OFFSET_DAYS,
546: m.DESCRIPTION
547: FROM IBY_APPLICABLE_PMT_MTHDS am,
548: IBY_PAYMENT_METHODS_VL m
549: WHERE am.PAYMENT_FLOW = 'DISBURSEMENTS'
550: AND am.APPLICABLE_TYPE_CODE = 'PAYEE'
551: AND am.APPLICABLE_VALUE_TO is null

Line 619: FROM IBY_APPLICABLE_PMT_MTHDS apmthds

615: SELECT Payment_Method_Code,
616: Applicable_Type_Code,
617: Applicable_Value_From,
618: Applicable_Value_To
619: FROM IBY_APPLICABLE_PMT_MTHDS apmthds
620: WHERE apmthds.Payment_method_code = p_payment_method_code
621: AND (apmthds.application_id = p_application_id
622: OR apmthds.application_id is NULL);
623:

Line 1744: IBY_APPLICABLE_PMT_MTHDS am1,

1740: IBY_PAYMENT_METHODS_VL m,
1741: IBY_FORMATS_VL f,
1742: IBY_DELIVERY_CHANNELS_VL d,
1743: IBY_PAYMENT_REASONS_VL r,
1744: IBY_APPLICABLE_PMT_MTHDS am1,
1745: IBY_APPLICABLE_PMT_MTHDS am2,
1746: IBY_APPLICABLE_PMT_MTHDS am3
1747: WHERE payee.payee_party_id = p_payee_party_id
1748: AND am1.PAYMENT_METHOD_CODE(+) = m.PAYMENT_METHOD_CODE

Line 1745: IBY_APPLICABLE_PMT_MTHDS am2,

1741: IBY_FORMATS_VL f,
1742: IBY_DELIVERY_CHANNELS_VL d,
1743: IBY_PAYMENT_REASONS_VL r,
1744: IBY_APPLICABLE_PMT_MTHDS am1,
1745: IBY_APPLICABLE_PMT_MTHDS am2,
1746: IBY_APPLICABLE_PMT_MTHDS am3
1747: WHERE payee.payee_party_id = p_payee_party_id
1748: AND am1.PAYMENT_METHOD_CODE(+) = m.PAYMENT_METHOD_CODE
1749: AND am1.PAYMENT_FLOW(+) = 'DISBURSEMENTS'

Line 1746: IBY_APPLICABLE_PMT_MTHDS am3

1742: IBY_DELIVERY_CHANNELS_VL d,
1743: IBY_PAYMENT_REASONS_VL r,
1744: IBY_APPLICABLE_PMT_MTHDS am1,
1745: IBY_APPLICABLE_PMT_MTHDS am2,
1746: IBY_APPLICABLE_PMT_MTHDS am3
1747: WHERE payee.payee_party_id = p_payee_party_id
1748: AND am1.PAYMENT_METHOD_CODE(+) = m.PAYMENT_METHOD_CODE
1749: AND am1.PAYMENT_FLOW(+) = 'DISBURSEMENTS'
1750: AND am1.APPLICABLE_TYPE_CODE(+) = 'PAY_PROC_TRXN_TYPE'

Line 1882: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am1

1878: AND pm.payment_method_code = m.payment_method_code
1879: AND pm.payment_function = p_payment_function
1880: AND pm.primary_flag = 'Y'
1881: AND (pm.inactive_date IS NULL OR pm.inactive_date >= trunc(sysdate))
1882: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am1
1883: WHERE am1.payment_method_code = m.payment_method_code
1884: AND am1.payment_flow(+) = 'DISBURSEMENTS'
1885: AND am1.applicable_type_code = 'PAY_PROC_TRXN_TYPE'
1886: AND (am1.applicable_value_to IS NULL OR

Line 1890: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am2

1886: AND (am1.applicable_value_to IS NULL OR
1887: am1.applicable_value_to=p_pay_proc_trxn_type_code)
1888: AND (am1.inactive_date IS null OR
1889: am1.inactive_date >= trunc(sysdate)))
1890: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am2
1891: WHERE am2.payment_method_code = m.payment_method_code
1892: AND am2.applicable_type_code = 'PAYER_LE'
1893: AND (am2.applicable_value_to IS NULL OR
1894: am2.applicable_value_to=p_payer_le_id)

Line 1897: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am3

1893: AND (am2.applicable_value_to IS NULL OR
1894: am2.applicable_value_to=p_payer_le_id)
1895: AND (am2.inactive_date IS NULL OR
1896: am2.inactive_date >= trunc(sysdate)))
1897: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am3
1898: WHERE am3.payment_method_code = m.payment_method_code
1899: AND am3.applicable_type_code = 'PAYER_ORG'
1900: AND (am3.applicable_value_to IS NULL OR
1901: am3.applicable_value_to=p_org_id)

Line 2779: IBY_APPLICABLE_PMT_MTHDS am1,

2775: ibypmtmthds.support_bills_payable_flag,
2776: ibypmtmthds.maturity_date_offset_days
2777: FROM IBY_PAYMENT_RULES ibypmtrules,
2778: IBY_PAYMENT_METHODS_VL ibypmtmthds,
2779: IBY_APPLICABLE_PMT_MTHDS am1,
2780: IBY_APPLICABLE_PMT_MTHDS am2,
2781: IBY_APPLICABLE_PMT_MTHDS am3
2782: WHERE ibypmtrules.payment_method_code = ibypmtmthds.payment_method_code
2783: AND ibypmtrules.application_id = p_application_id

Line 2780: IBY_APPLICABLE_PMT_MTHDS am2,

2776: ibypmtmthds.maturity_date_offset_days
2777: FROM IBY_PAYMENT_RULES ibypmtrules,
2778: IBY_PAYMENT_METHODS_VL ibypmtmthds,
2779: IBY_APPLICABLE_PMT_MTHDS am1,
2780: IBY_APPLICABLE_PMT_MTHDS am2,
2781: IBY_APPLICABLE_PMT_MTHDS am3
2782: WHERE ibypmtrules.payment_method_code = ibypmtmthds.payment_method_code
2783: AND ibypmtrules.application_id = p_application_id
2784: AND NVL(ibypmtmthds.inactive_date,trunc(sysdate)) >= trunc(sysdate)

Line 2781: IBY_APPLICABLE_PMT_MTHDS am3

2777: FROM IBY_PAYMENT_RULES ibypmtrules,
2778: IBY_PAYMENT_METHODS_VL ibypmtmthds,
2779: IBY_APPLICABLE_PMT_MTHDS am1,
2780: IBY_APPLICABLE_PMT_MTHDS am2,
2781: IBY_APPLICABLE_PMT_MTHDS am3
2782: WHERE ibypmtrules.payment_method_code = ibypmtmthds.payment_method_code
2783: AND ibypmtrules.application_id = p_application_id
2784: AND NVL(ibypmtmthds.inactive_date,trunc(sysdate)) >= trunc(sysdate)
2785: AND am1.payment_method_code=ibypmtmthds.payment_method_code