APPS.BEN_CWB_BACK_OUT_CONC dependencies on PAY_ELEMENT_ENTRIES_F

Line 227: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',

223: begin
224:
225: dt_api.find_dt_del_modes -- _and_dates
226: (p_effective_date => p_effective_date,
227: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',
228: p_base_key_column => 'ELEMENT_ENTRY_ID',
229: p_base_key_value => p_base_key_value,
230: p_zap => l_zap_mode,
231: p_delete => l_delete_mode,

Line 317: from pay_element_entries_f

313: --
314: cursor c_min_max_dt(p_element_entry_id number) is
315: select min(effective_start_date),
316: max(effective_end_date)
317: from pay_element_entries_f
318: where element_entry_id = p_element_entry_id;
319: --
320: l_min_start_date date;
321: l_max_end_date date;

Line 331: pay_element_entries_f pee,

327: pet.element_name,
328: pet.processing_type
329: from pay_element_types_f pet,
330: pay_element_links_f pel,
331: pay_element_entries_f pee,
332: pay_element_entry_values_f pev
333: where pev.element_entry_value_id = p_element_entry_value_id
334: and pee.element_entry_id = pev.element_entry_id
335: and pev.effective_start_date between pee.effective_start_date

Line 360: pay_element_entries_f pee,

356: pee.element_link_id,
357: pev.screen_entry_value
358: from per_all_assignments_f asg,
359: pay_element_links_f pel,
360: pay_element_entries_f pee,
361: pay_element_entry_values_f pev
362: where asg.person_id = p_person_id
363: and pee.assignment_id = asg.assignment_id
364: and p_effective_date between asg.effective_start_date

Line 386: from pay_element_entries_f pee

382: -- added for 8392328
383: cursor c_get_ovn (p_element_entry_id in number
384: ,p_effective_date in date) is
385: select object_version_number
386: from pay_element_entries_f pee
387: where pee.element_entry_id = p_element_entry_id
388: and p_effective_date = pee.effective_end_date;
389: --
390: begin