DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_PAYMENT_REASONS_VL

Line 1722: FROM IBY_PAYMENT_REASONS_VL ibypr

1718: SELECT payment_reason_code,
1719: description,
1720: meaning,
1721: territory_code
1722: FROM IBY_PAYMENT_REASONS_VL ibypr
1723: WHERE (ibypr.territory_code = p_payer_country OR ibypr.territory_code is NULL)
1724: AND (ibypr.inactive_date is NULL OR ibypr.inactive_date >= trunc(sysdate));
1725:
1726: CURSOR payer_country_csr(p_payer_le_id NUMBER)

Line 1944: IBY_PAYMENT_REASONS_VL r,

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,
1946: IBY_APPLICABLE_PMT_MTHDS am2,
1947: IBY_APPLICABLE_PMT_MTHDS am3
1948: WHERE payee.payee_party_id = p_payee_party_id

Line 2022: IBY_PAYMENT_REASONS_VL r

2018: FROM
2019: IBY_EXTERNAL_PAYEES_ALL payee,
2020: IBY_FORMATS_VL f,
2021: IBY_DELIVERY_CHANNELS_VL d,
2022: IBY_PAYMENT_REASONS_VL r
2023: WHERE
2024: payee.ext_payee_id IN
2025: (
2026: p_payee1,