DBA Data[Home] [Help]

APPS.PAY_SET_BUS dependencies on PAY_ELEMENT_TEMPLATES

Line 28: from pay_element_templates pet

24: select pet.business_group_id
25: , pet.legislation_code
26: , pet.template_type
27: , pet.base_processing_priority
28: from pay_element_templates pet
29: where pet.template_id = p_template_id;
30: --
31: l_proc varchar2(72) := g_package||'get_template_info';
32: l_api_updating boolean;

Line 132: from pay_element_templates pet

128: -- Cursor to check that template_id is valid.
129: --
130: cursor csr_template_id_valid is
131: select null
132: from pay_element_templates pet
133: where pet.template_id = p_template_id;
134: --
135: l_proc varchar2(72) := g_package||'chk_template_id';
136: l_valid varchar2(1);

Line 577: , pay_element_templates pet

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'
581: and pet.business_group_id = p_business_group_id;