DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on PAY_ELEMENT_LINKS_F

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

2045: p_element_name in pay_element_types_f.element_name%type
2046: ,p_input_value_name in pay_input_values_f.name%type
2047: ,p_assignment_id in pay_element_entries_f.assignment_id%type
2048: ,p_effective_date in date
2049: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type
2050: ,p_input_value_id out nocopy pay_input_values_f.input_value_id%type
2051: ,p_element_entry_id out nocopy pay_element_entries_f.element_entry_id%type
2052: ,p_value out nocopy pay_element_entry_values_f.screen_entry_value%type
2053: ,p_object_version_number out nocopy pay_element_entries_f.object_version_number%type ) is

Line 2092: pay_element_links_f eli,

2088: eli.element_link_id,
2089: ele.element_entry_id
2090: from
2091: pay_input_values_f ipv,
2092: pay_element_links_f eli,
2093: ghr_element_entries_h_v ele
2094: where
2095: trunc(eff_date) between ipv.effective_start_date
2096: and ipv.effective_end_date