APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_FORMATS_VL

Line 1267: FROM IBY_FORMATS_VL f

1263:
1264: CURSOR payment_formats_csr(p_payment_format_code VARCHAR2)
1265: IS
1266: SELECT COUNT(f.format_code)
1267: FROM IBY_FORMATS_VL f
1268: WHERE f.format_code = p_payment_format_code;
1269:
1270: CURSOR pmt_mthds_csr(p_payment_mthd_code VARCHAR2)
1271: IS

Line 1385: -- 7. Validate Payment Format Code (table: IBY_FORMATS_VL)

1381: l_valid := FALSE;
1382: END IF;
1383: END IF;
1384:
1385: -- 7. Validate Payment Format Code (table: IBY_FORMATS_VL)
1386: -- is not mandatory
1387: IF (p_ext_payee_rec.Pmt_Format IS NOT NULL) THEN
1388: OPEN payment_formats_csr(p_ext_payee_rec.Pmt_Format);
1389: FETCH payment_formats_csr INTO l_count;

Line 1394: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_FORMATS_VL');

1390: CLOSE payment_formats_csr;
1391:
1392: IF (l_count = 0) THEN
1393: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1394: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_FORMATS_VL');
1395: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pmt_Format);
1396: FND_MSG_PUB.Add;
1397: l_valid := FALSE;
1398: END IF;