APPS.QP_VALIDATE_CURR_DETAILS dependencies on QP_LOOKUPS

Line 321: FROM qp_lookups

317: -- oe_debug_pub.add('VALIDATE Details conversion_method');
318:
319: SELECT 'X'
320: INTO l_dummy_c
321: FROM qp_lookups
322: WHERE lookup_type = 'CONVERSION_METHOD'
323: and lookup_code = p_CURR_DETAILS_rec.conversion_method;
324:
325: EXCEPTION

Line 353: FROM qp_lookups

349: Begin
350: -- If conversion_type is not in GL, then check if it is defined as lookup_code
351: SELECT 'X'
352: INTO l_dummy_c
353: FROM qp_lookups
354: WHERE lookup_type = 'CONVERSION_METHOD'
355: and lookup_code = p_CURR_DETAILS_rec.conversion_type
356: and enabled_flag = 'Y' and
357: trunc(sysdate) between

Line 380: FROM qp_lookups

376: -- oe_debug_pub.add('VALIDATE Details conversion_date_type');
377:
378: SELECT 'X'
379: INTO l_dummy_c
380: FROM qp_lookups
381: WHERE lookup_type = 'CONVERSION_DATE_TYPE'
382: and lookup_code = p_CURR_DETAILS_rec.conversion_date_type
383: and enabled_flag = 'Y' and
384: trunc(sysdate) between

Line 405: FROM qp_lookups

401: -- oe_debug_pub.add('VALIDATE Details markup_operator');
402:
403: SELECT 'X'
404: INTO l_dummy_c
405: FROM qp_lookups
406: WHERE lookup_type = 'MARKUP_OPERATOR'
407: and lookup_code = p_CURR_DETAILS_rec.markup_operator
408: and enabled_flag = 'Y' and
409: trunc(sysdate) between

Line 606: FROM qp_lookups

602: -- oe_debug_pub.add('VALIDATE Details curr_attribute_type');
603:
604: SELECT 'X'
605: INTO l_dummy_c
606: FROM qp_lookups
607: WHERE lookup_type = 'MULTI_CURR_ATTRIBUTE_TYPE'
608: and lookup_code = p_CURR_DETAILS_rec.curr_attribute_type
609: and enabled_flag = 'Y' and
610: trunc(sysdate) between