DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on PAY_ELEMENT_LINKS_F

Line 1949: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type

1945: p_element_name in pay_element_types_f.element_name%type
1946: ,p_input_value_name in pay_input_values_f.name%type
1947: ,p_assignment_id in pay_element_entries_f.assignment_id%type
1948: ,p_effective_date in date
1949: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type
1950: ,p_input_value_id out nocopy pay_input_values_f.input_value_id%type
1951: ,p_element_entry_id out nocopy pay_element_entries_f.element_entry_id%type
1952: ,p_value out nocopy pay_element_entry_values_f.screen_entry_value%type
1953: ,p_object_version_number out nocopy pay_element_entries_f.object_version_number%type ) is

Line 1992: pay_element_links_f eli,

1988: eli.element_link_id,
1989: ele.element_entry_id
1990: from
1991: pay_input_values_f ipv,
1992: pay_element_links_f eli,
1993: ghr_element_entries_h_v ele
1994: where
1995: trunc(eff_date) between ipv.effective_start_date
1996: and ipv.effective_end_date