DBA Data[Home] [Help]

APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on DUAL

Line 335: FROM DUAL) Vehtrn

331: ,hr_transaction_api.get_number_value
332: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
333: ,hr_transaction_api.get_number_Value
334: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
335: FROM DUAL) Vehtrn
336: ,hr_lookups lkp
337: WHERE vehtrn.vehicle_type=lkp.lookup_code
338: AND lkp.lookup_type='PQP_VEHICLE_TYPE' ;
339:

Line 646: FROM DUAL;

642: ,hr_transaction_api.get_varchar2_value
643: (p_transaction_step_id, 'P_VAL_INFORMATION19') val_information19
644: ,hr_transaction_api.get_varchar2_value
645: (p_transaction_step_id, 'P_VAL_INFORMATION20') val_information20
646: FROM DUAL;
647:
648: RETURN csr;
649: END get_vehicle_details;
650: