APPS.PER_ABB_BUS dependencies on PAY_INPUT_VALUES_F

Line 204: -- Must correspond to a row on pay_input_values_f on both date_effective and date_end

200: -- Description:
201: -- Validates input_value_id
202: -- Must be null if BG is null
203: -- Once it is not null, it cannot be changed.
204: -- Must correspond to a row on pay_input_values_f on both date_effective and date_end
205: -- Must correspond to an element type of processing type N,
206: -- or processing type R with not null proration group
207: --
208: -- Prerequisites:

Line 246: from pay_input_values_f piv1, per_business_groups_perf pbg

242: l_input_end date;
243: --
244: cursor csr_valid_input_value_bg is
245: select 1
246: from pay_input_values_f piv1, per_business_groups_perf pbg
247: where piv1.input_value_id = p_input_value_id
248: and pbg.business_group_id = p_business_group_id
249: and nvl(piv1.business_group_id,p_business_group_id) = p_business_group_id
250: and nvl(piv1.legislation_code,pbg.legislation_code) = pbg.legislation_code;

Line 254: from pay_input_values_f

250: and nvl(piv1.legislation_code,pbg.legislation_code) = pbg.legislation_code;
251: --
252: cursor csr_input_end is
253: select max(effective_end_date)
254: from pay_input_values_f
255: where input_value_id = p_input_value_id;
256: --
257: cursor csr_valid_input_value_dates is
258: select 1

Line 259: from pay_input_values_f piv1, per_business_groups_perf pbg

255: where input_value_id = p_input_value_id;
256: --
257: cursor csr_valid_input_value_dates is
258: select 1
259: from pay_input_values_f piv1, per_business_groups_perf pbg
260: where piv1.input_value_id = p_input_value_id
261: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date
262: and exists (select 1
263: from pay_input_values_f piv2

Line 263: from pay_input_values_f piv2

259: from pay_input_values_f piv1, per_business_groups_perf pbg
260: where piv1.input_value_id = p_input_value_id
261: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date
262: and exists (select 1
263: from pay_input_values_f piv2
264: where piv1.input_value_id = piv2.input_value_id
265: and nvl(l_date_end,hr_api.g_eot) between
266: piv2.effective_start_date and piv2.effective_end_date);
267: --

Line 270: from pay_input_values_f piv1, per_business_groups_perf pbg

266: piv2.effective_start_date and piv2.effective_end_date);
267: --
268: cursor csr_valid_input_value_uom is
269: select 1
270: from pay_input_values_f piv1, per_business_groups_perf pbg
271: where piv1.input_value_id = p_input_value_id
272: and piv1.uom in ('ND','H_HH','H_DECIMAL1','H_DECIMAL2','H_DECIMAL3')
273: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date;
274: --

Line 277: from pay_element_types_f pet, pay_input_values_f piv

273: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date;
274: --
275: cursor csr_valid_element_type is
276: select 1
277: from pay_element_types_f pet, pay_input_values_f piv
278: where p_input_value_id = piv.input_value_id
279: and p_date_effective between piv.effective_start_date and piv.effective_end_date
280: and piv.element_type_id = pet.element_type_id
281: and p_date_effective between pet.effective_start_date and pet.effective_end_date

Line 638: l_input_uom pay_input_values_f.uom%type;

634: ) is
635: --
636: l_proc varchar2(72) := g_package || 'chk_hours_or_days';
637: l_api_updating boolean;
638: l_input_uom pay_input_values_f.uom%type;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'||l_proc,10);