DBA Data[Home] [Help]

APPS.PAY_SBT_BUS dependencies on PAY_ELEMENT_TEMPLATES

Line 24: from pay_element_templates pet

20: --
21: cursor csr_get_template_info is
22: select pet.business_group_id
23: , pet.template_type
24: from pay_element_templates pet
25: where pet.template_id = p_template_id;
26: --
27: l_proc varchar2(72) := g_package||'get_template_info';
28: l_api_updating boolean;

Line 157: from pay_element_templates pet

153: -- Cursor to check that template_id is valid.
154: --
155: cursor csr_template_id_valid is
156: select null
157: from pay_element_templates pet
158: where pet.template_id = p_template_id;
159: --
160: l_proc varchar2(72) := g_package||'chk_template_id';
161: l_valid varchar2(1);

Line 215: , pay_element_templates pet

211: --
212: cursor csr_U_balance_name_exists is
213: select null
214: from pay_shadow_balance_types sbt
215: , pay_element_templates pet
216: where upper(sbt.balance_name) = upper(p_balance_name)
217: and pet.template_id = sbt.template_id
218: and pet.template_type = 'U'
219: and pet.business_group_id = p_business_group_id;