eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ICD_ELEMENT_ENTRY_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 15: cursor dt_row_exists is select 'Y' from pay_element_entries_f a, pay_element_entries_f b

11: ,p_effective_start_date in date
12: ,p_effective_date in date
13: ,p_datetrack_mode in varchar2) return varchar2 is
14:
15: cursor dt_row_exists is select 'Y' from pay_element_entries_f a, pay_element_entries_f b
16: where a.element_entry_id = p_element_entry_id
17: and a.effective_start_date = p_effective_start_Date
18: and b.element_entry_id = a.element_entry_id
19: and b.effective_start_date = a.effective_end_Date+1;

Line 162: where element_type_id = (select element_type_id from pay_element_entries_f where

158:
159: cursor c_input_values is
160: select * from
161: pay_input_values_f
162: where element_type_id = (select element_type_id from pay_element_entries_f where
163: element_entry_id = p_element_entry_id and p_effective_date between effective_start_date and effective_end_date)
164: and p_effective_date between effective_start_date and effective_end_date
165: order by input_value_id asc;
166: