DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_DELIVERY_CHANNELS_VL

Line 109: FROM IBY_DELIVERY_CHANNELS_VL ibydlv

105: SELECT delivery_channel_code,
106: meaning,
107: description,
108: territory_code
109: FROM IBY_DELIVERY_CHANNELS_VL ibydlv
110: WHERE (ibydlv.territory_code = p_payer_country OR ibydlv.territory_code is NULL)
111: AND (ibydlv.inactive_date is NULL OR ibydlv.inactive_date >= trunc(sysdate));
112:
113: CURSOR payer_country_csr(p_payer_le_id NUMBER)

Line 1943: IBY_DELIVERY_CHANNELS_VL d,

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,
1946: IBY_APPLICABLE_PMT_MTHDS am2,
1947: IBY_APPLICABLE_PMT_MTHDS am3

Line 2021: IBY_DELIVERY_CHANNELS_VL d,

2017: r.territory_code payment_reason_country
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: (