APPS.PAY_TCO_BUS dependencies on PAY_ELEMENT_TEMPLATES

Line 22: from pay_element_templates pet

18: -- Cursor to get the template information.
19: --
20: cursor csr_get_template_info is
21: select pet.business_group_id
22: from pay_element_templates pet
23: where pet.template_id = p_template_id;
24: --
25: l_proc varchar2(72) := g_package||'get_template_info';
26: l_api_updating boolean;

Line 144: from pay_element_templates pet

140: -- Cursor to check that template_id is valid.
141: --
142: cursor csr_template_id_valid is
143: select null
144: from pay_element_templates pet
145: where pet.template_id = p_template_id
146: and pet.template_type = 'U';
147: --
148: l_proc varchar2(72) := g_package||'chk_template_id';