DBA Data[Home] [Help]

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: -- Bugfix 10271804
176: -- p_business_group_id is obsolete so fetch business group of assignment
177: l_business_group_id per_assignments_f.business_group_id%TYPE;
178: --

Line 206: pay_element_types_f et,

202: SELECT /*+ LEADING(ee)
203: INDEX(ee pay_element_entries_f_n51) */
204: 'X'
205: FROM pay_element_entries_f ee,
206: pay_element_types_f et,
207: pay_element_links_f el
208: WHERE el.element_link_id = ee.element_link_id
209: AND el.element_link_id = p_element_link_id
210: AND el.element_type_id = et.element_type_id

Line 237: FROM pay_element_types_f et,

233: -- Bugfix 3079267
234: -- Retreive the indirect_only_flag
235: --
236: et.indirect_only_flag
237: FROM pay_element_types_f et,
238: pay_element_links_f el
239: WHERE el.element_link_id = p_element_link_id
240: /* Bug # 8628917. Validating element and link against BG ID*/
241: AND el.business_group_id = l_business_group_id