APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_PAYMENT_REASONS_VL

Line 1250: FROM IBY_PAYMENT_REASONS_VL ibypr

1246: CURSOR pmt_reasons_csr(p_pmt_reason_code VARCHAR2,
1247: p_payer_country VARCHAR2)
1248: IS
1249: SELECT COUNT(payment_reason_code)
1250: FROM IBY_PAYMENT_REASONS_VL ibypr
1251: WHERE ibypr.payment_reason_code = p_pmt_reason_code
1252: AND (ibypr.territory_code = p_payer_country OR ibypr.territory_code is NULL)
1253: AND (ibypr.inactive_date is NULL OR ibypr.inactive_date >= trunc(sysdate));
1254:

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

1349:
1350: l_valid := l_valid AND l_temp_valid;
1351: END IF;
1352:
1353: -- 5. Validate Payment Reason Code (table: IBY_PAYMENT_REASONS_VL by country)
1354: -- is not mandatory
1355: IF (p_ext_payee_rec.Pay_Reason_Code IS NOT NULL) THEN
1356: OPEN pmt_reasons_csr(p_ext_payee_rec.Pay_Reason_Code,l_payee_country);
1357: FETCH pmt_reasons_csr INTO l_count;

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

1358: CLOSE pmt_reasons_csr;
1359:
1360: IF (l_count = 0) THEN
1361: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1362: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_REASONS_VL');
1363: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pay_Reason_Code);
1364: FND_MSG_PUB.Add;
1365: l_valid := FALSE;
1366: END IF;