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.

[Home] [Help]

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 2134: DELETE from hr_api_transaction_values

2130: OPEN c_del_values;
2131: FETCH c_del_values INTO l_del_values;
2132: CLOSE c_del_values;
2133:
2134: DELETE from hr_api_transaction_values
2135: WHERE transaction_step_id = l_del_values.transaction_step_id;
2136: l_transaction_step_id := l_del_values.transaction_step_id;
2137: END IF;
2138:

Line 3298: DELETE from hr_api_transaction_values

3294: FETCH c_del_values INTO l_del_values;
3295: CLOSE c_del_values;
3296:
3297: hr_utility.set_location('leaving c del value :',20);
3298: DELETE from hr_api_transaction_values
3299: WHERE transaction_step_id = l_del_values.transaction_step_id;
3300: l_transaction_step_id := l_del_values.transaction_step_id;
3301: hr_utility.set_location('leaving delete :',25);
3302: END IF;

Line 3578: FROM hr_api_transaction_values hatv

3574: l_transaction_id NUMBER;
3575: CURSOR c_get_count
3576: IS
3577: SELECT count(hatv.name)
3578: FROM hr_api_transaction_values hatv
3579: WHERE hatv.transaction_step_id=p_transaction_step_id
3580: AND hatv.name like 'P_PERSON_USR_ID%';
3581: --
3582: --