APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_DELIVERY_CHANNELS_VL

Line 79: FROM IBY_DELIVERY_CHANNELS_VL ibydlv

75: SELECT delivery_channel_code,
76: meaning,
77: description,
78: territory_code
79: FROM IBY_DELIVERY_CHANNELS_VL ibydlv
80: WHERE (ibydlv.territory_code = p_payer_country OR ibydlv.territory_code is NULL)
81: AND (ibydlv.inactive_date is NULL OR ibydlv.inactive_date >= trunc(sysdate));
82:
83: CURSOR payer_country_csr(p_payer_le_id NUMBER)

Line 1742: IBY_DELIVERY_CHANNELS_VL d,

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,
1745: IBY_APPLICABLE_PMT_MTHDS am2,
1746: IBY_APPLICABLE_PMT_MTHDS am3

Line 1819: IBY_DELIVERY_CHANNELS_VL d,

1815: r.territory_code payment_reason_country
1816: FROM
1817: IBY_EXTERNAL_PAYEES_ALL payee,
1818: IBY_FORMATS_VL f,
1819: IBY_DELIVERY_CHANNELS_VL d,
1820: IBY_PAYMENT_REASONS_VL r
1821: WHERE
1822: payee.ext_payee_id IN
1823: (