APPS.PAY_ITR_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 303: -- inserted or updated exists on pay_element_types_f and is date effective.

299: -- {Start Of Comments}
300: --
301: -- Description:
302: -- This procedure is used to check that the element_type of the row being
303: -- inserted or updated exists on pay_element_types_f and is date effective.
304: --
305: -- Prerequisites:
306: -- This procedure is called from the update_validate and insert_validate.
307: --

Line 333: from pay_element_types_f et

329: l_proc varchar2(72) := g_package||'chk_element_type_id';
330: --
331: Cursor C1 is
332: select distinct et.element_type_id
333: from pay_element_types_f et
334: where et.element_type_id = p_element_type_id
335: and (p_validation_start_date between et.effective_start_date
336: and et.effective_end_date
337: or ( p_validation_start_date < et.effective_start_date

Line 403: from pay_element_types_f e

399: l_proc varchar2(72) := g_package||'chk_result_name ';
400: --
401: cursor C1 is
402: select distinct f.item_name
403: from pay_element_types_f e
404: ,ff_fdi_usages_f f
405: where e.element_type_id = p_element_type_id
406: and e.iterative_formula_id = f.formula_id
407: and f.usage in ('O', 'B')