APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PQP_CONFIGURATION_VALUES

Line 352: FROM pqp_configuration_values pcv

348:
349: CURSOR c_get_config_value_rates (cp_leg_code VARCHAR2)
350: IS
351: SELECT PCV_INFORMATION13 info
352: FROM pqp_configuration_values pcv
353: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
354: AND (pcv.business_group_id=p_business_group_id OR
355: ( legislation_code = 'GB' AND
356: NOT EXISTS

Line 357: (SELECT 'X' from pqp_configuration_values pcv

353: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
354: AND (pcv.business_group_id=p_business_group_id OR
355: ( legislation_code = 'GB' AND
356: NOT EXISTS
357: (SELECT 'X' from pqp_configuration_values pcv
358: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
359: AND pcv.business_group_id=p_business_group_id ))) ;
360:
361:

Line 365: FROM pqp_configuration_values pcv

361:
362: CURSOR c_get_config_value_taxinf (cp_leg_code VARCHAR2)
363: IS
364: SELECT PCV_INFORMATION14 info
365: FROM pqp_configuration_values pcv
366: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
367: AND (pcv.business_group_id=p_business_group_id OR
368: ( legislation_code = 'GB' AND
369: NOT EXISTS

Line 370: (SELECT 'X' from pqp_configuration_values pcv

366: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
367: AND (pcv.business_group_id=p_business_group_id OR
368: ( legislation_code = 'GB' AND
369: NOT EXISTS
370: (SELECT 'X' from pqp_configuration_values pcv
371: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
372: AND pcv.business_group_id=p_business_group_id ))) ;
373:
374:

Line 378: FROM pqp_configuration_values pcv

374:
375: CURSOR c_get_config_value_puiinf (cp_leg_code VARCHAR2)
376: IS
377: SELECT PCV_INFORMATION15 info
378: FROM pqp_configuration_values pcv
379: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
380: AND (pcv.business_group_id=p_business_group_id OR
381: ( legislation_code = 'GB' AND
382: NOT EXISTS

Line 383: (SELECT 'X' from pqp_configuration_values pcv

379: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
380: AND (pcv.business_group_id=p_business_group_id OR
381: ( legislation_code = 'GB' AND
382: NOT EXISTS
383: (SELECT 'X' from pqp_configuration_values pcv
384: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
385: AND pcv.business_group_id=p_business_group_id ))) ;
386:
387:

Line 389: l_legislation_code pqp_configuration_values.legislation_code%TYPE;

385: AND pcv.business_group_id=p_business_group_id ))) ;
386:
387:
388: l_get_config_value c_get_config_value_rates%ROWTYPE;
389: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
390: BEGIN
391: l_legislation_code := pqp_car_mileage_functions.
392: get_legislation_code (p_business_group_id);
393: IF p_info_type = 'Rates' THEN

Line 445: FROM pqp_configuration_values pcv

441: ,cp_fuel_type VARCHAR2
442: )
443: IS
444: SELECT pcv.pcv_information5 rates_type
445: FROM pqp_configuration_values pcv
446: WHERE business_group_id=p_business_group_id
447: AND pcv.pcv_information_category='GB_VEHICLE_CALC_INFO'
448: AND (pcv_information2=cp_usage_type
449: OR pcv_information2 IS NULL)

Line 527: FROM pqp_configuration_values pcv

523: ;*/
524: /*CURSOR c_get_config_info
525: IS
526: SELECT pcv_information1 calculation_method
527: FROM pqp_configuration_values pcv
528: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
529: AND pcv.legislation_code='GB'
530: AND NOT EXISTS (SELECT 'X'
531: FROM pqp_configuration_values pcv1

Line 531: FROM pqp_configuration_values pcv1

527: FROM pqp_configuration_values pcv
528: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
529: AND pcv.legislation_code='GB'
530: AND NOT EXISTS (SELECT 'X'
531: FROM pqp_configuration_values pcv1
532: WHERE pcv1.business_group_id=p_business_group_id)
533: UNION
534: SELECT pcv_information1 calculation_method
535: FROM pqp_configuration_values pcv

Line 535: FROM pqp_configuration_values pcv

531: FROM pqp_configuration_values pcv1
532: WHERE pcv1.business_group_id=p_business_group_id)
533: UNION
534: SELECT pcv_information1 calculation_method
535: FROM pqp_configuration_values pcv
536: WHERE pcv_information_category='PQP_VEHICLE_MILEAGE'
537: AND pcv.business_group_id=p_business_group_id;*/
538:
539: CURSOR c_get_veh_typ (cp_vehicle_id NUMBER)

Line 805: FROM pqp_configuration_values pcv

801: FETCH c_get_attr_val INTO l_get_attr_val;
802: EXIT WHEN c_get_attr_val%NOTFOUND;
803: IF l_get_attr_val.calculation_method IS NULL THEN
804: l_str_info :='SELECT pcv_information1 calculation_method
805: FROM pqp_configuration_values pcv
806: WHERE pcv_information_category=''PQP_VEHICLE_MILEAGE''
807: AND pcv.legislation_code=''GB''
808: AND NOT EXISTS (SELECT ''X''
809: FROM pqp_configuration_values pcv1

Line 809: FROM pqp_configuration_values pcv1

805: FROM pqp_configuration_values pcv
806: WHERE pcv_information_category=''PQP_VEHICLE_MILEAGE''
807: AND pcv.legislation_code=''GB''
808: AND NOT EXISTS (SELECT ''X''
809: FROM pqp_configuration_values pcv1
810: WHERE pcv1.business_group_id='||p_business_group_id ||'
811: -- added to check for this info category only (5632627)
812: AND pcv1.pcv_information_category=''PQP_VEHICLE_MILEAGE'')
813: UNION

Line 815: FROM pqp_configuration_values pcv

811: -- added to check for this info category only (5632627)
812: AND pcv1.pcv_information_category=''PQP_VEHICLE_MILEAGE'')
813: UNION
814: SELECT pcv_information1 calculation_method
815: FROM pqp_configuration_values pcv
816: WHERE pcv_information_category=''PQP_VEHICLE_MILEAGE''
817: AND pcv.business_group_id='||p_business_group_id;
818:
819: OPEN c_get_config_info FOR l_str_info;

Line 839: FROM pqp_configuration_values pcv

835: FETCH c_get_table_name INTO l_rates_table_name;
836: CLOSE c_get_table_name;
837: ELSE
838: l_str :='SELECT pcv.pcv_information5 rates_type
839: FROM pqp_configuration_values pcv
840: WHERE business_group_id='||p_business_group_id||
841: ' AND pcv.pcv_information_category=''GB_VEHICLE_CALC_INFO''
842: AND (pcv_information2='||'''||l_car_type||'''||
843: ' OR pcv_information2 IS NULL)