APPS.HR_ELEMENT_LINKS dependencies on PAY_ELEMENT_ENTRIES_F

Line 454: from pay_element_entries_f ee

450: into l_validation_ok
451: from sys.dual
452: where exists
453: (select 1
454: from pay_element_entries_f ee
455: where p_element_link_id = ee.element_link_id);
456: --
457: exception
458: when NO_DATA_FOUND then NULL;

Line 529: pay_element_entries_f ee,

525: from sys.dual
526: where exists
527: (select 1
528: from pay_element_types_f et,
529: pay_element_entries_f ee,
530: pay_element_links_f el
531: where p_element_link_id = el.element_link_id
532: and el.element_type_id = et.element_type_id
533: and et.processing_type = 'N'

Line 557: from pay_element_entries_f ee

553: into l_delete_ok
554: from sys.dual
555: where exists
556: (select 1
557: from pay_element_entries_f ee
558: where p_element_link_id = ee.element_link_id
559: and ee.entry_type = 'D'
560: and p_val_start_date <= ee.effective_end_date
561: and p_val_end_date >= ee.effective_start_date);

Line 921: from pay_element_entries_f ee

917: p_val_end_date date) is
918: select ee.element_entry_id element_entry_id,
919: ee.effective_start_date start_date,
920: ee.effective_end_date end_date
921: from pay_element_entries_f ee
922: where p_element_link_id = ee.element_link_id
923: and p_val_start_date <= ee.effective_end_date
924: and p_val_end_date >= ee.effective_start_date
925: for update;

Line 950: delete from pay_element_entries_f

946: --
947: delete from pay_link_input_values_f
948: where element_link_id = p_element_link_id;
949: --
950: delete from pay_element_entries_f
951: where element_link_id = p_element_link_id;
952: --
953: delete from pay_assignment_link_usages_f
954: where element_link_id = p_element_link_id;

Line 978: delete from pay_element_entries_f

974: hr_utility.set_location('hr_element_links.del_3p_element_link', 3);
975: --
976: --
977: -- delete all future records
978: delete from pay_element_entries_f
979: where element_link_id = p_element_link_id
980: and effective_start_date > p_val_session_date;
981: --
982: -- update current records so that the end date is the session date

Line 983: update pay_element_entries_f

979: where element_link_id = p_element_link_id
980: and effective_start_date > p_val_session_date;
981: --
982: -- update current records so that the end date is the session date
983: update pay_element_entries_f
984: set effective_end_date = p_val_session_date
985: where element_link_id = p_element_link_id
986: and p_val_session_date between
987: effective_start_date and effective_end_date;

Line 1214: from pay_element_entries_f

1210: v_dummy number(1);
1211: --
1212: cursor csr_element_entries is
1213: select 1
1214: from pay_element_entries_f
1215: where element_link_id = p_link_id;
1216: --
1217: begin
1218: --