[Home] [Help]
2513:
2514: CURSOR c_get_lkp_meaning
2515: IS
2516: SELECT hl.meaning
2517: FROM hr_lookups hl
2518: WHERE hl.lookup_type=p_lookup_type
2519: AND hl.lookup_code=p_lookup_code;
2520:
2521:
2543: CURSOR c_get_meaning_u
2544: IS
2545: SELECT lkp.lookup_code
2546: ,lkp.meaning
2547: FROM hr_lookups lkp
2548: WHERE lkp.lookup_type IN ('PQP_PRIVATE_VEHICLE_USER'
2549: ,'PQP_COMPANY_VEHICLE_USER')
2550: AND lkp.lookup_code=p_code;
2551: --AND lkp.application_id=8303
2554: CURSOR c_get_meaning_o
2555: IS
2556: SELECT lkp.lookup_code
2557: ,lkp.meaning
2558: FROM hr_lookups lkp
2559: WHERE lookup_type in ('PQP_VEHICLE_OWNERSHIP_TYPE')
2560: AND lkp.lookup_code=p_code;
2561: --AND lkp.application_id=8303
2562:
2562:
2563: CURSOR c_get_meaning_f
2564: IS
2565: select meaning
2566: from hr_lookups
2567: where lookup_type = 'PQP_FUEL_TYPE'
2568: and enabled_flag = 'Y'
2569: and lookup_code = p_code;
2570:
2570:
2571: CURSOR c_get_meaning_cm
2572: IS
2573: select meaning
2574: from hr_lookups
2575: where lookup_type = 'PQP_VEHICLE_CALC_METHOD'
2576: and enabled_flag='Y'
2577: and lookup_code = p_code;
2578:
2579: CURSOR c_get_meaning_vt
2580: IS
2581: select hl.meaning
2582: from pqp_vehicle_repository_f pvr,
2583: hr_lookups hl
2584: where pvr.registration_number = p_code
2585: and hl.lookup_type = 'PQP_VEHICLE_TYPE'
2586: and hl.enabled_flag = 'Y'
2587: and hl.lookup_code = pvr.vehicle_type;
2588:
2589: CURSOR c_get_meaning_vehtype
2590: IS
2591: select hl.meaning
2592: from hr_lookups hl
2593: where hl.lookup_type = 'PQP_VEHICLE_TYPE'
2594: and hl.enabled_flag = 'Y'
2595: and hl.lookup_code = p_code;
2596:
2607:
2608:
2609: l_get_meaning_u c_get_meaning_u%ROWTYPE;
2610: l_get_meaning_o c_get_meaning_o%ROWTYPE;
2611: l_meaning hr_lookups.meaning%TYPE;
2612:
2613: l_proc varchar2(72) := g_package ||'get_meaning';
2614: BEGIN
2615: