DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_PAYMENT_METHODS_VL

Line 548: IBY_PAYMENT_METHODS_VL m

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
552: AND (am.APPLICATION_ID is null OR am.APPLICATION_ID = p_application_id)

Line 577: IBY_PAYMENT_METHODS_VL m

573: m.MATURITY_DATE_OFFSET_DAYS,
574: m.DESCRIPTION
575: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,
576: IBY_EXTERNAL_PAYEES_ALL payee,
577: IBY_PAYMENT_METHODS_VL m
578: WHERE ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
579: AND ppm.PAYMENT_FUNCTION = p_payment_function
580: AND (ppm.INACTIVE_DATE is null OR ppm.INACTIVE_DATE >= trunc(sysdate))
581: AND ppm.PAYMENT_METHOD_CODE = m.PAYMENT_METHOD_CODE

Line 595: FROM IBY_PAYMENT_METHODS_VL pmthds

591: pmthds.Payment_Method_Code,
592: pmthds.SUPPORT_BILLS_PAYABLE_FLAG,
593: pmthds.MATURITY_DATE_OFFSET_DAYS,
594: pmthds.DESCRIPTION
595: FROM IBY_PAYMENT_METHODS_VL pmthds
596: WHERE (pmthds.inactive_date is NULL OR pmthds.inactive_date >= trunc(sysdate))
597: AND NOT EXISTS (select 1
598: from IBY_EXT_PARTY_PMT_MTHDS ppm,
599: IBY_EXTERNAL_PAYEES_ALL payee

Line 1740: IBY_PAYMENT_METHODS_VL m,

1736: d.territory_code delivery_channel_country,
1737: r.territory_code payment_reason_country
1738: FROM IBY_EXTERNAL_PAYEES_ALL payee,
1739: IBY_EXT_PARTY_PMT_MTHDS pm,
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,

Line 1868: IBY_PAYMENT_METHODS_VL m

1864: m.maturity_date_offset_days
1865: FROM
1866: IBY_EXTERNAL_PAYEES_ALL payee,
1867: IBY_EXT_PARTY_PMT_MTHDS pm,
1868: IBY_PAYMENT_METHODS_VL m
1869: WHERE
1870: payee.ext_payee_id IN (
1871: p_payee1,
1872: p_payee2,

Line 2515: IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE,

2511: PROCEDURE Get_Payment_Field_Properties (
2512: p_api_version IN NUMBER,
2513: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2514: p_payment_method_id IN
2515: IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE,
2516: x_return_status OUT NOCOPY VARCHAR2,
2517: x_msg_count OUT NOCOPY NUMBER,
2518: x_msg_data OUT NOCOPY VARCHAR2,
2519: x_Payment_Field_Properties OUT NOCOPY Applicable_Pmt_Attrs_Rec_Type

Line 2778: IBY_PAYMENT_METHODS_VL ibypmtmthds,

2774: ibypmtmthds.payment_method_name,
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