APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on PAY_ELEMENT_LINKS_F

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

391: --
392: g_package varchar2(80) := 'ben_determine_activity_base_rt';
393: g_debug boolean := hr_utility.debug_enabled;
394: --
395: TYPE g_element_link_id_table IS TABLE OF pay_element_links_f.element_link_id%TYPE
396: INDEX BY BINARY_INTEGER;
397: --
398: -------------------------------------------------------------------------------
399: -- get_expr_val

Line 1126: from pay_element_links_f p

1122: l_abr_level c_abr_level%ROWTYPE;
1123: --
1124: cursor c_elem_link(p_element_type_id number) is
1125: select p.element_link_id
1126: from pay_element_links_f p
1127: where element_type_id = p_element_type_id
1128: and p_effective_date between p.effective_start_date
1129: and p.effective_end_date;
1130: --

Line 1131: l_elem_link pay_element_links_f.element_link_id%TYPE;

1127: where element_type_id = p_element_type_id
1128: and p_effective_date between p.effective_start_date
1129: and p.effective_end_date;
1130: --
1131: l_elem_link pay_element_links_f.element_link_id%TYPE;
1132: --
1133: l_element_link_id_table g_element_link_id_table;
1134: --
1135: l_input_value_id pay_input_values_f.input_value_id%TYPE;