APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_PAYMENT_REASONS_VL

Line 1541: FROM IBY_PAYMENT_REASONS_VL ibypr

1537: SELECT payment_reason_code,
1538: description,
1539: meaning,
1540: territory_code
1541: FROM IBY_PAYMENT_REASONS_VL ibypr
1542: WHERE (ibypr.territory_code = p_payer_country OR ibypr.territory_code is NULL)
1543: AND (ibypr.inactive_date is NULL OR ibypr.inactive_date >= trunc(sysdate));
1544:
1545: CURSOR payer_country_csr(p_payer_le_id NUMBER)

Line 1743: IBY_PAYMENT_REASONS_VL r,

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
1747: WHERE payee.payee_party_id = p_payee_party_id

Line 1820: IBY_PAYMENT_REASONS_VL r

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: (
1824: p_payee1,