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_UTILITIES dependencies on PAY_DATETRACKED_EVENTS

Line 3441: FROM pay_datetracked_events pde

3437:
3438: CURSOR csr_chk_eg_for_ee_tab
3439: IS
3440: SELECT 'Y'
3441: FROM pay_datetracked_events pde
3442: ,pay_dated_tables pdt
3443: WHERE event_group_id = p_event_group_id
3444: AND pde.dated_table_id = pdt.dated_table_id
3445: AND (pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

Line 3486: ,pay_datetracked_events pde

3482: SELECT distinct pee.element_entry_id
3483: ,pde.datetracked_event_id
3484: FROM pay_element_set_members pes
3485: ,pay_element_entries_f pee
3486: ,pay_datetracked_events pde
3487: WHERE pes.element_set_id = p_element_set_id
3488: AND pee.element_type_id = pes.element_type_id
3489: AND pee.assignment_id = p_assignment_id
3490: AND pde.event_group_id = p_event_group_id

Line 3506: FROM pay_datetracked_events pde

3502: -- element entries in the event group.
3503: CURSOR csr_get_purge_events_on_eg
3504: IS
3505: SELECT datetracked_event_id
3506: FROM pay_datetracked_events pde
3507: ,pay_dated_tables pdt
3508: WHERE event_group_id = p_event_group_id
3509: AND pde.dated_table_id = pdt.dated_table_id
3510: AND pde.update_type = 'P'