[Home] [Help]
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
634: AND (am.APPLICATION_ID is null OR am.APPLICATION_ID = p_application_id)
655: m.MATURITY_DATE_OFFSET_DAYS,
656: m.DESCRIPTION
657: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,
658: IBY_EXTERNAL_PAYEES_ALL payee,
659: IBY_PAYMENT_METHODS_VL m
660: WHERE ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
661: AND ppm.PAYMENT_FUNCTION = p_payment_function
662: AND (m.INACTIVE_DATE is null OR m.INACTIVE_DATE >= trunc(sysdate))
663: AND (ppm.INACTIVE_DATE is null OR ppm.INACTIVE_DATE >= trunc(sysdate))
673: pmthds.Payment_Method_Code,
674: pmthds.SUPPORT_BILLS_PAYABLE_FLAG,
675: pmthds.MATURITY_DATE_OFFSET_DAYS,
676: pmthds.DESCRIPTION
677: FROM IBY_PAYMENT_METHODS_VL pmthds
678: WHERE (pmthds.inactive_date is NULL OR pmthds.inactive_date >= trunc(sysdate))
679: AND NOT EXISTS (select 1
680: from IBY_EXT_PARTY_PMT_MTHDS ppm,
681: IBY_EXTERNAL_PAYEES_ALL payee
1937: d.territory_code delivery_channel_country,
1938: r.territory_code payment_reason_country
1939: FROM IBY_EXTERNAL_PAYEES_ALL payee,
1940: IBY_EXT_PARTY_PMT_MTHDS pm,
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,
2066: m.maturity_date_offset_days
2067: FROM
2068: IBY_EXTERNAL_PAYEES_ALL payee,
2069: IBY_EXT_PARTY_PMT_MTHDS pm,
2070: IBY_PAYMENT_METHODS_VL m
2071: WHERE
2072: payee.ext_payee_id IN (
2073: p_payee1,
2074: p_payee2,
2849: PROCEDURE Get_Payment_Field_Properties (
2850: p_api_version IN NUMBER,
2851: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2852: p_payment_method_id IN
2853: IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE,
2854: x_return_status OUT NOCOPY VARCHAR2,
2855: x_msg_count OUT NOCOPY NUMBER,
2856: x_msg_data OUT NOCOPY VARCHAR2,
2857: x_Payment_Field_Properties OUT NOCOPY Applicable_Pmt_Attrs_Rec_Type
3134: ibypmtmthds.payment_method_name,
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