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_LOG_ALIEN_DATA_CHANGES dependencies on PAY_PROCESS_EVENTS

Line 353: -- the event in the table pay_process_events.

349: PROCEDURE log_events (p_assignment_id in number
350: ,p_effective_date in date ) IS
351: --
352: -- Procedure to check whether the event is already logged, if not it logs
353: -- the event in the table pay_process_events.
354: --
355: CURSOR c_asg_exists is
356: SELECT 'x'
357: FROM pay_process_events

Line 357: FROM pay_process_events

353: -- the event in the table pay_process_events.
354: --
355: CURSOR c_asg_exists is
356: SELECT 'x'
357: FROM pay_process_events
358: WHERE assignment_id = p_assignment_id
359: AND change_type = 'PQP_US_ALIEN_WINDSTAR'
360: AND status in ('N', 'D'); -- NOT_READ, DATA_VALIDATION_FAILED
361: --

Line 374: --call pay_process_events API

370: OPEN c_asg_exists;
371: FETCH c_asg_exists into l_temp;
372: IF c_asg_exists%NOTFOUND THEN
373: BEGIN
374: --call pay_process_events API
375: pay_ppe_api.create_process_event
376: (p_validate => FALSE
377: ,p_assignment_id => p_assignment_id
378: ,p_effective_date => p_effective_date