DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on PAY_DATETRACKED_EVENTS

Line 1932: FROM pay_datetracked_events pde

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

Line 2108: FROM pay_datetracked_events pde

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

Line 2126: FROM pay_datetracked_events pde

2122: WHERE event_group_id = p_event_group_id;
2123:
2124: CURSOR csr_get_dte_ids IS
2125: SELECT datetracked_event_id
2126: FROM pay_datetracked_events pde
2127: WHERE pde.event_group_id = p_event_group_id;
2128:
2129:
2130: CURSOR csr_get_purge_events_ids IS

Line 2132: FROM pay_datetracked_events pde

2128:
2129:
2130: CURSOR csr_get_purge_events_ids IS
2131: SELECT datetracked_event_id
2132: FROM pay_datetracked_events pde
2133: ,pay_dated_tables pdt
2134: WHERE event_group_id = p_event_group_id
2135: AND pde.dated_table_id = pdt.dated_table_id
2136: AND pde.update_type = 'P'