APPS.BEN_EXT_UTIL dependencies on PAY_ELEMENT_ENTRIES_F

Line 1917: ,pay_element_entries_f pee

1913: )
1914: IS
1915: SELECT distinct pee.element_entry_id
1916: FROM pay_element_type_rules petr
1917: ,pay_element_entries_f pee
1918: WHERE petr.element_set_id = p_element_set_id
1919: AND pee.element_type_id = petr.element_type_id
1920: AND pee.assignment_id = p_assignment_id
1921: AND (

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

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';
1938:
1939:
1940: -- this is used to fetch the element entry ids of the
1941: -- puged element entries.

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

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
2114: pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
2115: )
2116: AND ROWNUM < 2;

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

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';
2138:
2139:
2140:
2141: l_element_set_ids_tab t_number;