DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on FND_CURRENCIES

Line 1211: FROM FND_CURRENCIES

1207: IF p_header_rec.currency_code(I) is not null THEN
1208: BEGIN
1209: SELECT -1*PRECISION, -1*EXTENDED_PRECISION
1210: INTO l_precision, l_extended_precision
1211: FROM FND_CURRENCIES
1212: WHERE CURRENCY_CODE = P_header_rec.CURRENCY_CODE(I);
1213: EXCEPTION
1214: WHEN NO_DATA_FOUND THEN
1215: p_header_rec.process_status_flag(I):=NULL;

Line 5117: FROM fnd_currencies_vl

5113: AND qpih.process_status_flag ='P' --is null
5114: AND qpih.currency_code is not null
5115: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5116: AND NOT EXISTS (SELECT currency_code -- Validation
5117: FROM fnd_currencies_vl
5118: WHERE enabled_flag = 'Y'
5119: AND currency_flag='Y'
5120: AND currency_code = qpih.currency_code
5121: );