APPS.HR_ELEMENT_LINKS dependencies on PAY_ELEMENT_LINKS_F

Line 29: PAY_ELEMENT_LINKS_F

25: Name : hr_element_links
26: --
27: Description : This package holds procedures and functions related to the
28: following tables :
29: PAY_ELEMENT_LINKS_F
30: --
31: Uses : hr_element_links
32: hr_input_values
33: Used By : n/a

Line 476: from pay_element_links_f

472: into l_validation_not_ok
473: from sys.dual
474: where p_val_start_date =
475: (select min(effective_start_date)
476: from pay_element_links_f
477: where p_element_link_id = element_link_id)
478: and p_val_end_date =
479: (select max(effective_end_date)
480: from pay_element_links_f

Line 480: from pay_element_links_f

476: from pay_element_links_f
477: where p_element_link_id = element_link_id)
478: and p_val_end_date =
479: (select max(effective_end_date)
480: from pay_element_links_f
481: where p_element_link_id = element_link_id);
482: --
483: exception
484: when NO_DATA_FOUND then NULL;

Line 530: pay_element_links_f el

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'
534: and ee.element_link_id = el.element_link_id

Line 1017: from pay_element_links_f et1

1013: begin
1014: --
1015: select 'Y'
1016: into l_on_final_record
1017: from pay_element_links_f et1
1018: where p_element_link_id = et1.element_link_id
1019: and p_val_session_date between
1020: et1.effective_start_date and et1.effective_end_date
1021: and et1.effective_end_date =

Line 1023: from pay_element_links_f et2

1019: and p_val_session_date between
1020: et1.effective_start_date and et1.effective_end_date
1021: and et1.effective_end_date =
1022: (select max(et2.effective_end_date)
1023: from pay_element_links_f et2
1024: where p_element_link_id = et2.element_link_id);
1025: --
1026: exception
1027: when NO_DATA_FOUND then NULL;

Line 1053: from pay_element_links_f

1049: where element_link_id = p_element_link_id;
1050: --
1051: select min(effective_start_date), greatest(max(effective_end_date),p_val_end_date)
1052: into v_alu_start_date, v_alu_end_date
1053: from pay_element_links_f
1054: where element_link_id = p_element_link_id;
1055: --
1056: --
1057: pay_asg_link_usages_pkg.insert_ALU (