eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on HR_API_TRANSACTION_VALUES

Line 362: hr_api_transaction_values a,

358: SELECT DISTINCT (a.number_value) person_usr_id
359: , b.number_value assignment_usr_id
360: , c.varchar2_value usr_type
361: FROM hr_api_transaction_steps s,
362: hr_api_transaction_values a,
363: hr_api_transaction_steps s1,
364: hr_api_transaction_values b,
365: hr_api_transaction_steps s2,
366: hr_api_transaction_values c

Line 364: hr_api_transaction_values b,

360: , c.varchar2_value usr_type
361: FROM hr_api_transaction_steps s,
362: hr_api_transaction_values a,
363: hr_api_transaction_steps s1,
364: hr_api_transaction_values b,
365: hr_api_transaction_steps s2,
366: hr_api_transaction_values c
367: WHERE s.transaction_step_id = a.transaction_step_id
368: AND s1.transaction_step_id = b.transaction_step_id

Line 366: hr_api_transaction_values c

362: hr_api_transaction_values a,
363: hr_api_transaction_steps s1,
364: hr_api_transaction_values b,
365: hr_api_transaction_steps s2,
366: hr_api_transaction_values c
367: WHERE s.transaction_step_id = a.transaction_step_id
368: AND s1.transaction_step_id = b.transaction_step_id
369: AND s2.transaction_step_id = c.transaction_step_id
370: AND s.transaction_step_id = p_transaction_step_id

Line 2147: DELETE from hr_api_transaction_values

2143: OPEN c_del_values;
2144: FETCH c_del_values INTO l_del_values;
2145: CLOSE c_del_values;
2146:
2147: DELETE from hr_api_transaction_values
2148: WHERE transaction_step_id = l_del_values.transaction_step_id;
2149: l_transaction_step_id := l_del_values.transaction_step_id;
2150: END IF;
2151:

Line 3323: DELETE from hr_api_transaction_values

3319: FETCH c_del_values INTO l_del_values;
3320: CLOSE c_del_values;
3321:
3322: hr_utility.set_location('leaving c del value :',20);
3323: DELETE from hr_api_transaction_values
3324: WHERE transaction_step_id = l_del_values.transaction_step_id;
3325: l_transaction_step_id := l_del_values.transaction_step_id;
3326: hr_utility.set_location('leaving delete :',25);
3327: END IF;

Line 3603: FROM hr_api_transaction_values hatv

3599: l_transaction_id NUMBER;
3600: CURSOR c_get_count
3601: IS
3602: SELECT count(hatv.name)
3603: FROM hr_api_transaction_values hatv
3604: WHERE hatv.transaction_step_id=p_transaction_step_id
3605: AND hatv.name like 'P_PERSON_USR_ID%';
3606: --
3607: --