DBA Data[Home] [Help]

APPS.HR_TEMPLATE_EXISTENCE dependencies on PAY_ELEMENT_TYPES_F

Line 221: from pay_element_types_f pet,

217: ff.formula_text
218: into already_exists,
219: p_ff_name,
220: p_ff_text
221: from pay_element_types_f pet,
222: pay_status_processing_rules_f spr,
223: ff_formulas_f ff
224: where upper(pet.element_name) = upper(p_ele_name)
225: and pet.business_group_id = p_bg_id

Line 330: FROM pay_element_types_f pet

326: hr_utility.set_location('hr_template_existence.ele_exists',10);
327:
328: SELECT pet.element_type_id
329: INTO already_exists
330: FROM pay_element_types_f pet
331: WHERE pet.element_name = p_ele_name
332: AND pet.business_group_id = p_bg_id
333: AND p_eff_date between pet.effective_start_date and pet.effective_end_date;
334: