DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on FND_CURRENCIES

Line 1367: FROM FND_CURRENCIES

1363: IF p_header_rec.currency_code(I) is not null THEN
1364: BEGIN
1365: SELECT -1*PRECISION, -1*EXTENDED_PRECISION
1366: INTO l_precision, l_extended_precision
1367: FROM FND_CURRENCIES
1368: WHERE CURRENCY_CODE = P_header_rec.CURRENCY_CODE(I);
1369: EXCEPTION
1370: WHEN NO_DATA_FOUND THEN
1371: p_header_rec.process_status_flag(I):=NULL;

Line 5129: FROM fnd_currencies_vl

5125: AND qpih.process_status_flag ='P' --is null
5126: AND qpih.currency_code is not null
5127: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5128: AND NOT EXISTS (SELECT currency_code -- Validation
5129: FROM fnd_currencies_vl
5130: WHERE enabled_flag = 'Y'
5131: AND currency_flag='Y'
5132: AND currency_code = qpih.currency_code
5133: );