APPS.HR_ELEMENT_LINKS dependencies on PAY_LINK_INPUT_VALUES_F

Line 676: from pay_link_input_values_f LINK,

672: -- default value
673: --
674: cursor csr_link_defaults is
675: select 1
676: from pay_link_input_values_f LINK,
677: pay_input_values_f TYPE
678: where link.element_link_id = p_element_link_id
679: and link.input_value_id = type.input_value_id
680: and type.mandatory_flag = 'Y'

Line 798: update pay_link_input_values_f

794: --
795: if (p_old_costable_type = 'C' or p_old_costable_type = 'F')
796: and (p_costable_type = 'D' or p_costable_type = 'N') then
797: --
798: update pay_link_input_values_f
799: set costed_flag = 'N'
800: where costed_flag = 'Y'
801: and p_element_link_id = element_link_id;
802: --

Line 808: update pay_link_input_values_f liv

804: -- costed then the pay_value will become costed.
805: elsif (p_old_costable_type = 'D' or p_old_costable_type = 'N') and
806: (p_costable_type = 'F' or p_costable_type = 'C') then
807: --
808: update pay_link_input_values_f liv
809: set liv.costed_flag = 'Y'
810: where p_element_link_id = liv.element_link_id
811: and liv.input_value_id =
812: (select iv.input_value_id

Line 947: delete from pay_link_input_values_f

943: --
944: --
945: if p_delete_mode = 'ZAP' then
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;

Line 962: delete from pay_link_input_values_f

958: --
959: hr_utility.set_location('hr_element_links.del_3p_element_link', 2);
960: --
961: -- delete all future records
962: delete from pay_link_input_values_f
963: where element_link_id = p_element_link_id
964: and effective_start_date > p_val_session_date;
965: --
966: -- update current records so that the end date is the session date

Line 967: update pay_link_input_values_f

963: where element_link_id = p_element_link_id
964: and effective_start_date > p_val_session_date;
965: --
966: -- update current records so that the end date is the session date
967: update pay_link_input_values_f
968: set effective_end_date = p_val_session_date
969: where element_link_id = p_element_link_id
970: and p_val_session_date between
971: effective_start_date and effective_end_date;

Line 1035: update pay_link_input_values_f iv1

1031: --
1032: --
1033: hr_utility.set_location('hr_element_links.del_3p_element_link', 5);
1034: --
1035: update pay_link_input_values_f iv1
1036: set iv1.effective_end_date = p_val_end_date
1037: where p_element_link_id = iv1.element_link_id
1038: and iv1.effective_end_date =
1039: (select max(iv2.effective_end_date)

Line 1040: from pay_link_input_values_f iv2

1036: set iv1.effective_end_date = p_val_end_date
1037: where p_element_link_id = iv1.element_link_id
1038: and iv1.effective_end_date =
1039: (select max(iv2.effective_end_date)
1040: from pay_link_input_values_f iv2
1041: where iv2.link_input_value_id = iv1.link_input_value_Id);
1042: --
1043: end if;
1044: --