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 629: FROM IBY_APPLICABLE_PMT_MTHDS am,

625: am.PAYMENT_METHOD_CODE,
626: m.SUPPORT_BILLS_PAYABLE_FLAG,
627: m.MATURITY_DATE_OFFSET_DAYS,
628: m.DESCRIPTION
629: FROM IBY_APPLICABLE_PMT_MTHDS am,
630: IBY_PAYMENT_METHODS_VL m
631: WHERE am.PAYMENT_FLOW = 'DISBURSEMENTS'
632: AND am.APPLICABLE_TYPE_CODE = 'PAYEE'
633: AND am.APPLICABLE_VALUE_TO is null

Line 700: FROM IBY_APPLICABLE_PMT_MTHDS apmthds

696: SELECT Payment_Method_Code,
697: Applicable_Type_Code,
698: Applicable_Value_From,
699: Applicable_Value_To
700: FROM IBY_APPLICABLE_PMT_MTHDS apmthds
701: WHERE apmthds.Payment_method_code = p_payment_method_code
702: AND (apmthds.application_id = p_application_id
703: OR apmthds.application_id is NULL);
704:

Line 1945: IBY_APPLICABLE_PMT_MTHDS am1,

1941: IBY_PAYMENT_METHODS_VL m,
1942: IBY_FORMATS_VL f,
1943: IBY_DELIVERY_CHANNELS_VL d,
1944: IBY_PAYMENT_REASONS_VL r,
1945: IBY_APPLICABLE_PMT_MTHDS am1,
1946: IBY_APPLICABLE_PMT_MTHDS am2,
1947: IBY_APPLICABLE_PMT_MTHDS am3
1948: WHERE payee.payee_party_id = p_payee_party_id
1949: AND am1.PAYMENT_METHOD_CODE(+) = m.PAYMENT_METHOD_CODE

Line 1946: IBY_APPLICABLE_PMT_MTHDS am2,

1942: IBY_FORMATS_VL f,
1943: IBY_DELIVERY_CHANNELS_VL d,
1944: IBY_PAYMENT_REASONS_VL r,
1945: IBY_APPLICABLE_PMT_MTHDS am1,
1946: IBY_APPLICABLE_PMT_MTHDS am2,
1947: IBY_APPLICABLE_PMT_MTHDS am3
1948: WHERE payee.payee_party_id = p_payee_party_id
1949: AND am1.PAYMENT_METHOD_CODE(+) = m.PAYMENT_METHOD_CODE
1950: AND am1.PAYMENT_FLOW(+) = 'DISBURSEMENTS'

Line 1947: IBY_APPLICABLE_PMT_MTHDS am3

1943: IBY_DELIVERY_CHANNELS_VL d,
1944: IBY_PAYMENT_REASONS_VL r,
1945: IBY_APPLICABLE_PMT_MTHDS am1,
1946: IBY_APPLICABLE_PMT_MTHDS am2,
1947: IBY_APPLICABLE_PMT_MTHDS am3
1948: WHERE payee.payee_party_id = p_payee_party_id
1949: AND am1.PAYMENT_METHOD_CODE(+) = m.PAYMENT_METHOD_CODE
1950: AND am1.PAYMENT_FLOW(+) = 'DISBURSEMENTS'
1951: AND am1.APPLICABLE_TYPE_CODE(+) = 'PAY_PROC_TRXN_TYPE'

Line 2085: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am1

2081: AND pm.payment_function = p_payment_function
2082: AND pm.primary_flag = 'Y'
2083: AND (pm.inactive_date IS NULL OR pm.inactive_date >= trunc(sysdate))
2084: AND (m.inactive_date IS NULL OR m.inactive_date >= trunc(sysdate))
2085: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am1
2086: WHERE am1.payment_method_code = m.payment_method_code
2087: AND am1.payment_flow(+) = 'DISBURSEMENTS'
2088: AND am1.applicable_type_code = 'PAY_PROC_TRXN_TYPE'
2089: AND (am1.applicable_value_to IS NULL OR

Line 2093: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am2

2089: AND (am1.applicable_value_to IS NULL OR
2090: am1.applicable_value_to=p_pay_proc_trxn_type_code)
2091: AND (am1.inactive_date IS null OR
2092: am1.inactive_date >= trunc(sysdate)))
2093: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am2
2094: WHERE am2.payment_method_code = m.payment_method_code
2095: AND am2.applicable_type_code = 'PAYER_LE'
2096: AND (am2.applicable_value_to IS NULL OR
2097: am2.applicable_value_to=p_payer_le_id)

Line 2100: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am3

2096: AND (am2.applicable_value_to IS NULL OR
2097: am2.applicable_value_to=p_payer_le_id)
2098: AND (am2.inactive_date IS NULL OR
2099: am2.inactive_date >= trunc(sysdate)))
2100: AND EXISTS (SELECT 1 FROM IBY_APPLICABLE_PMT_MTHDS am3
2101: WHERE am3.payment_method_code = m.payment_method_code
2102: AND am3.applicable_type_code = 'PAYER_ORG'
2103: AND (am3.applicable_value_to IS NULL OR
2104: am3.applicable_value_to=p_org_id)

Line 3139: IBY_APPLICABLE_PMT_MTHDS am1,

3135: ibypmtmthds.support_bills_payable_flag,
3136: ibypmtmthds.maturity_date_offset_days
3137: FROM IBY_PAYMENT_RULES ibypmtrules,
3138: IBY_PAYMENT_METHODS_VL ibypmtmthds,
3139: IBY_APPLICABLE_PMT_MTHDS am1,
3140: IBY_APPLICABLE_PMT_MTHDS am2,
3141: IBY_APPLICABLE_PMT_MTHDS am3
3142: WHERE ibypmtrules.payment_method_code = ibypmtmthds.payment_method_code
3143: AND ibypmtrules.application_id = p_application_id

Line 3140: IBY_APPLICABLE_PMT_MTHDS am2,

3136: ibypmtmthds.maturity_date_offset_days
3137: FROM IBY_PAYMENT_RULES ibypmtrules,
3138: IBY_PAYMENT_METHODS_VL ibypmtmthds,
3139: IBY_APPLICABLE_PMT_MTHDS am1,
3140: IBY_APPLICABLE_PMT_MTHDS am2,
3141: IBY_APPLICABLE_PMT_MTHDS am3
3142: WHERE ibypmtrules.payment_method_code = ibypmtmthds.payment_method_code
3143: AND ibypmtrules.application_id = p_application_id
3144: AND NVL(ibypmtmthds.inactive_date,trunc(sysdate)) >= trunc(sysdate)

Line 3141: IBY_APPLICABLE_PMT_MTHDS am3

3137: FROM IBY_PAYMENT_RULES ibypmtrules,
3138: IBY_PAYMENT_METHODS_VL ibypmtmthds,
3139: IBY_APPLICABLE_PMT_MTHDS am1,
3140: IBY_APPLICABLE_PMT_MTHDS am2,
3141: IBY_APPLICABLE_PMT_MTHDS am3
3142: WHERE ibypmtrules.payment_method_code = ibypmtmthds.payment_method_code
3143: AND ibypmtrules.application_id = p_application_id
3144: AND NVL(ibypmtmthds.inactive_date,trunc(sysdate)) >= trunc(sysdate)
3145: AND am1.payment_method_code=ibypmtmthds.payment_method_code