APPS.PAY_SET_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 566: from pay_shadow_element_types pset

562: -- (template_type = 'T').
563: --
564: cursor csr_T_element_name_exists is
565: select null
566: from pay_shadow_element_types pset
567: where pset.template_id = p_template_id
568: and upper(nvl(pset.element_name, hr_api.g_varchar2)) =
569: upper(nvl(p_element_name, hr_api.g_varchar2));
570: --

Line 576: from pay_shadow_element_types pset

572: -- (template type = 'U').
573: --
574: cursor csr_U_element_name_exists is
575: select null
576: from pay_shadow_element_types pset
577: , pay_element_templates pet
578: where upper(pset.element_name) = upper(p_element_name)
579: and pet.template_id = pset.template_id
580: and pet.template_type = 'U'

Line 851: from pay_shadow_element_types pset

847: and nvl(sf.formula_type_name,pay_sf_shd.g_payroll_formula_type) = pay_sf_shd.g_payroll_formula_type
848: and sf.business_group_id = p_business_group_id
849: and not exists
850: (select null
851: from pay_shadow_element_types pset
852: where pset.payroll_formula_id = p_payroll_formula_id
853: and pset.template_id <> p_template_id);
854: --
855: l_proc varchar2(72) := g_package||'chk_payroll_formula_id';