APPS.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on PQH_SS_VALUE_HISTORY

Line 19: FROM pqh_ss_value_history psvh

15:
16: CURSOR c_get_conf_no (cp_element_entry_id NUMBER)
17: IS
18: SELECT psvh.value conf_number
19: FROM pqh_ss_value_history psvh
20: WHERE psvh.name='P_CONFIRMATION_NUMBER'
21: AND psvh.value IS NOT NULL
22: AND psvh.step_history_id IN
23: (SELECT psvh1.step_history_id

Line 24: FROM pqh_ss_value_history psvh1

20: WHERE psvh.name='P_CONFIRMATION_NUMBER'
21: AND psvh.value IS NOT NULL
22: AND psvh.step_history_id IN
23: (SELECT psvh1.step_history_id
24: FROM pqh_ss_value_history psvh1
25: WHERE psvh1.name='P_ELEMENT_ENTRY_ID'
26: AND psvh1.value =cp_element_entry_id);
27:
28: