[Home] [Help]
2527:
2528: CURSOR c_get_lkp_meaning
2529: IS
2530: SELECT hl.meaning
2531: FROM hr_lookups hl
2532: WHERE hl.lookup_type=p_lookup_type
2533: AND hl.lookup_code=p_lookup_code;
2534:
2535:
2557: CURSOR c_get_meaning_u
2558: IS
2559: SELECT lkp.lookup_code
2560: ,lkp.meaning
2561: FROM hr_lookups lkp
2562: WHERE lkp.lookup_type IN ('PQP_PRIVATE_VEHICLE_USER'
2563: ,'PQP_COMPANY_VEHICLE_USER')
2564: AND lkp.lookup_code=p_code;
2565: --AND lkp.application_id=8303
2568: CURSOR c_get_meaning_o
2569: IS
2570: SELECT lkp.lookup_code
2571: ,lkp.meaning
2572: FROM hr_lookups lkp
2573: WHERE lookup_type in ('PQP_VEHICLE_OWNERSHIP_TYPE')
2574: AND lkp.lookup_code=p_code;
2575: --AND lkp.application_id=8303
2576:
2576:
2577: CURSOR c_get_meaning_f
2578: IS
2579: select meaning
2580: from hr_lookups
2581: where lookup_type = 'PQP_FUEL_TYPE'
2582: and enabled_flag = 'Y'
2583: and lookup_code = p_code;
2584:
2584:
2585: CURSOR c_get_meaning_cm
2586: IS
2587: select meaning
2588: from hr_lookups
2589: where lookup_type = 'PQP_VEHICLE_CALC_METHOD'
2590: and enabled_flag='Y'
2591: and lookup_code = p_code;
2592:
2593: CURSOR c_get_meaning_vt
2594: IS
2595: select hl.meaning
2596: from pqp_vehicle_repository_f pvr,
2597: hr_lookups hl
2598: where pvr.registration_number = p_code
2599: and hl.lookup_type = 'PQP_VEHICLE_TYPE'
2600: and hl.enabled_flag = 'Y'
2601: and hl.lookup_code = pvr.vehicle_type;
2602:
2603: CURSOR c_get_meaning_vehtype
2604: IS
2605: select hl.meaning
2606: from hr_lookups hl
2607: where hl.lookup_type = 'PQP_VEHICLE_TYPE'
2608: and hl.enabled_flag = 'Y'
2609: and hl.lookup_code = p_code;
2610:
2621:
2622:
2623: l_get_meaning_u c_get_meaning_u%ROWTYPE;
2624: l_get_meaning_o c_get_meaning_o%ROWTYPE;
2625: l_meaning hr_lookups.meaning%TYPE;
2626:
2627: l_proc varchar2(72) := g_package ||'get_meaning';
2628: BEGIN
2629: