APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_PAYMENT_REASONS_VL

Line 1512: FROM IBY_PAYMENT_REASONS_VL ibypr

1508:
1509: CURSOR pmt_reasons_csr(p_pmt_reason_code VARCHAR2)
1510: IS
1511: SELECT COUNT(payment_reason_code)
1512: FROM IBY_PAYMENT_REASONS_VL ibypr
1513: WHERE ibypr.payment_reason_code = p_pmt_reason_code
1514: AND (ibypr.inactive_date is NULL OR ibypr.inactive_date >= trunc(sysdate));
1515:
1516: CURSOR dlv_channels_csr(p_dlv_channel_code VARCHAR2)

Line 1642: -- 5. Validate Payment Reason Code (table: IBY_PAYMENT_REASONS_VL by country)

1638: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1639: print_debuginfo(l_module_name, 'Validate Payment Reason Code');
1640: print_debuginfo(l_module_name, 'Payment Reason Code::'||p_ext_payee_rec.Pay_Reason_Code);
1641: END IF;
1642: -- 5. Validate Payment Reason Code (table: IBY_PAYMENT_REASONS_VL by country)
1643: -- is not mandatory
1644: IF (p_ext_payee_rec.Pay_Reason_Code IS NOT NULL) THEN
1645: OPEN pmt_reasons_csr(p_ext_payee_rec.Pay_Reason_Code);
1646: FETCH pmt_reasons_csr INTO l_count;

Line 1654: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_REASONS_VL');

1650: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1651: print_debuginfo(l_module_name, 'InValid Payment Reason Code');
1652: END IF;
1653: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1654: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_REASONS_VL');
1655: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pay_Reason_Code);
1656: FND_MSG_PUB.Add;
1657: l_valid := FALSE;
1658: END IF;