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.BEN_EXT_UTIL dependencies on PAY_DATETRACKED_EVENTS

Line 1936: FROM pay_datetracked_events pde

1932: -- element entries in the event group.
1933: CURSOR csr_get_purge_events_on_eg
1934: IS
1935: SELECT datetracked_event_id
1936: FROM pay_datetracked_events pde
1937: ,pay_dated_tables pdt
1938: WHERE event_group_id = p_event_group_id
1939: AND pde.dated_table_id = pdt.dated_table_id
1940: AND pde.update_type = 'P'

Line 2112: FROM pay_datetracked_events pde

2108: l_proc VARCHAR2(70);
2109:
2110: CURSOR csr_chk_eg_for_ee_tab IS
2111: SELECT 'Y'
2112: FROM pay_datetracked_events pde
2113: ,pay_dated_tables pdt
2114: WHERE event_group_id = p_event_group_id
2115: AND pde.dated_table_id = pdt.dated_table_id
2116: AND (pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

Line 2130: FROM pay_datetracked_events pde

2126: WHERE event_group_id = p_event_group_id;
2127:
2128: CURSOR csr_get_dte_ids IS
2129: SELECT datetracked_event_id
2130: FROM pay_datetracked_events pde
2131: WHERE pde.event_group_id = p_event_group_id;
2132:
2133:
2134: CURSOR csr_get_purge_events_ids IS

Line 2136: FROM pay_datetracked_events pde

2132:
2133:
2134: CURSOR csr_get_purge_events_ids IS
2135: SELECT datetracked_event_id
2136: FROM pay_datetracked_events pde
2137: ,pay_dated_tables pdt
2138: WHERE event_group_id = p_event_group_id
2139: AND pde.dated_table_id = pdt.dated_table_id
2140: AND pde.update_type = 'P'