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.PAY_ELEMENT_ENTRY_API dependencies on PAY_ELEMENT_TYPES_F

Line 129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;

125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519
132: l_period_status per_time_periods.status%TYPE;
133: --

Line 130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;

126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519
132: l_period_status per_time_periods.status%TYPE;
133: --
134: -- Enhancement 2793978

Line 131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519

127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519
132: l_period_status per_time_periods.status%TYPE;
133: --
134: -- Enhancement 2793978
135: -- size of entry_value variables increased to deal with

Line 159: l_element_name pay_element_types_f.element_name%TYPE;

155: l_date_on_which_old_enough date;
156: l_dummy varchar2(1);
157: l_create_warning boolean;
158: l_proc varchar2(72) := g_package||'create_element_entry';
159: l_element_name pay_element_types_f.element_name%TYPE;
160: l_legislation_code pay_element_types_f.legislation_code%TYPE;
161: -- bug 659393, added variables for storing all dates pased in and truncate them
162: l_effective_date date;
163: l_date_earned pay_element_entries_f.date_earned%TYPE;

Line 160: l_legislation_code pay_element_types_f.legislation_code%TYPE;

156: l_dummy varchar2(1);
157: l_create_warning boolean;
158: l_proc varchar2(72) := g_package||'create_element_entry';
159: l_element_name pay_element_types_f.element_name%TYPE;
160: l_legislation_code pay_element_types_f.legislation_code%TYPE;
161: -- bug 659393, added variables for storing all dates pased in and truncate them
162: l_effective_date date;
163: l_date_earned pay_element_entries_f.date_earned%TYPE;
164: --

Line 174: l_indirect_only_flag pay_element_types_f.indirect_only_flag%TYPE;

170: -- Bugfix 3079267
171: -- l_indirect_only_flag required to hold indirect_only_flag value of the
172: -- element link
173: --
174: l_indirect_only_flag pay_element_types_f.indirect_only_flag%TYPE;
175: --
176: CURSOR c_output_variables IS
177: SELECT ee.object_version_number
178: FROM pay_element_entries_f ee

Line 198: pay_element_types_f et,

194: SELECT /*+ LEADING(ee)
195: INDEX(ee pay_element_entries_f_n51) */
196: 'X'
197: FROM pay_element_entries_f ee,
198: pay_element_types_f et,
199: pay_element_links_f el
200: WHERE el.element_link_id = ee.element_link_id
201: AND el.element_link_id = p_element_link_id
202: AND el.element_type_id = et.element_type_id

Line 228: FROM pay_element_types_f et,

224: -- Bugfix 3079267
225: -- Retreive the indirect_only_flag
226: --
227: et.indirect_only_flag
228: FROM pay_element_types_f et,
229: pay_element_links_f el
230: WHERE el.element_link_id = p_element_link_id
231: AND el.element_type_id = et.element_type_id
232: AND l_effective_date BETWEEN el.effective_start_date