APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on PAY_ELEMENT_LINKS_F

Line 378: TYPE g_element_link_id_table IS TABLE OF pay_element_links_f.element_link_id%TYPE

374: --
375: g_package varchar2(80) := 'ben_determine_activity_base_rt';
376: g_debug boolean := hr_utility.debug_enabled;
377: --
378: TYPE g_element_link_id_table IS TABLE OF pay_element_links_f.element_link_id%TYPE
379: INDEX BY BINARY_INTEGER;
380: --
381: -------------------------------------------------------------------------------
382: -- get_expr_val

Line 1109: from pay_element_links_f p

1105: l_abr_level c_abr_level%ROWTYPE;
1106: --
1107: cursor c_elem_link(p_element_type_id number) is
1108: select p.element_link_id
1109: from pay_element_links_f p
1110: where element_type_id = p_element_type_id
1111: and p_effective_date between p.effective_start_date
1112: and p.effective_end_date;
1113: --

Line 1114: l_elem_link pay_element_links_f.element_link_id%TYPE;

1110: where element_type_id = p_element_type_id
1111: and p_effective_date between p.effective_start_date
1112: and p.effective_end_date;
1113: --
1114: l_elem_link pay_element_links_f.element_link_id%TYPE;
1115: --
1116: l_element_link_id_table g_element_link_id_table;
1117: --
1118: l_input_value_id pay_input_values_f.input_value_id%TYPE;