DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on PAY_DATED_TABLES

Line 1933: ,pay_dated_tables pdt

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'
1937: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';

Line 2109: ,pay_dated_tables pdt

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'
2113: OR

Line 2133: ,pay_dated_tables pdt

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'
2137: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';