APPS.BEN_CWB_BACK_OUT_CONC dependencies on PAY_ELEMENT_ENTRIES_F

Line 206: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',

202: begin
203:
204: dt_api.find_dt_del_modes -- _and_dates
205: (p_effective_date => p_effective_date,
206: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',
207: p_base_key_column => 'ELEMENT_ENTRY_ID',
208: p_base_key_value => p_base_key_value,
209: p_zap => l_zap_mode,
210: p_delete => l_delete_mode,

Line 296: from pay_element_entries_f

292: --
293: cursor c_min_max_dt(p_element_entry_id number) is
294: select min(effective_start_date),
295: max(effective_end_date)
296: from pay_element_entries_f
297: where element_entry_id = p_element_entry_id;
298: --
299: l_min_start_date date;
300: l_max_end_date date;

Line 310: pay_element_entries_f pee,

306: pet.element_name,
307: pet.processing_type
308: from pay_element_types_f pet,
309: pay_element_links_f pel,
310: pay_element_entries_f pee,
311: pay_element_entry_values_f pev
312: where pev.element_entry_value_id = p_element_entry_value_id
313: and pee.element_entry_id = pev.element_entry_id
314: and pev.effective_start_date between pee.effective_start_date

Line 339: pay_element_entries_f pee,

335: pee.element_link_id,
336: pev.screen_entry_value
337: from per_all_assignments_f asg,
338: pay_element_links_f pel,
339: pay_element_entries_f pee,
340: pay_element_entry_values_f pev
341: where asg.person_id = p_person_id
342: and pee.assignment_id = asg.assignment_id
343: and p_effective_date between asg.effective_start_date