77:
78: CURSOR c_get_info
79: IS
80: SELECT pcv.pcv_information_category
81: , pqp_gb_mileage_claim_pkg.get_lkp_meaning
82: (pcv.pcv_information1,'PQP_VEHICLE_OWNERSHIP_TYPE')
83: Ownership
84: ,RPAD(DECODE (pcv.pcv_information1,'C',
85: pqp_gb_mileage_claim_pkg.get_lkp_meaning
81: , pqp_gb_mileage_claim_pkg.get_lkp_meaning
82: (pcv.pcv_information1,'PQP_VEHICLE_OWNERSHIP_TYPE')
83: Ownership
84: ,RPAD(DECODE (pcv.pcv_information1,'C',
85: pqp_gb_mileage_claim_pkg.get_lkp_meaning
86: (pcv.pcv_information2,'PQP_COMPANY_VEHICLE_USER'),
87: 'P',pqp_gb_mileage_claim_pkg.get_lkp_meaning
88: (pcv.pcv_information2,'PQP_PRIVATE_VEHICLE_USER')
89: ),10) Usage_type
83: Ownership
84: ,RPAD(DECODE (pcv.pcv_information1,'C',
85: pqp_gb_mileage_claim_pkg.get_lkp_meaning
86: (pcv.pcv_information2,'PQP_COMPANY_VEHICLE_USER'),
87: 'P',pqp_gb_mileage_claim_pkg.get_lkp_meaning
88: (pcv.pcv_information2,'PQP_PRIVATE_VEHICLE_USER')
89: ),10) Usage_type
90: , RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
91: (pcv.pcv_information3 ,'PQP_VEHICLE_TYPE'),10)
86: (pcv.pcv_information2,'PQP_COMPANY_VEHICLE_USER'),
87: 'P',pqp_gb_mileage_claim_pkg.get_lkp_meaning
88: (pcv.pcv_information2,'PQP_PRIVATE_VEHICLE_USER')
89: ),10) Usage_type
90: , RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
91: (pcv.pcv_information3 ,'PQP_VEHICLE_TYPE'),10)
92: Vehicle_type
93: ,RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
94: (pcv.pcv_information4,'PQP_FUEL_TYPE'),21)
89: ),10) Usage_type
90: , RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
91: (pcv.pcv_information3 ,'PQP_VEHICLE_TYPE'),10)
92: Vehicle_type
93: ,RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
94: (pcv.pcv_information4,'PQP_FUEL_TYPE'),21)
95: Fuel_type
96: ,RPAD(get_user_table_name(
97: TO_NUMBER(pcv.pcv_information5),