APPS.BEN_EXT_UTIL dependencies on PAY_ELEMENT_ENTRIES_F

Line 1921: ,pay_element_entries_f pee

1917: )
1918: IS
1919: SELECT distinct pee.element_entry_id
1920: FROM pay_element_type_rules petr
1921: ,pay_element_entries_f pee
1922: WHERE petr.element_set_id = p_element_set_id
1923: AND pee.element_type_id = petr.element_type_id
1924: AND pee.assignment_id = p_assignment_id
1925: AND (

Line 1941: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';

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'
1941: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';
1942:
1943:
1944: -- this is used to fetch the element entry ids of the
1945: -- puged element entries.

Line 2116: AND (pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

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'
2117: OR
2118: pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
2119: )
2120: AND ROWNUM < 2;

Line 2141: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';

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'
2141: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';
2142:
2143:
2144:
2145: l_element_set_ids_tab t_number;