APPS.PAY_SBT_BUS dependencies on PAY_SHADOW_BALANCE_TYPES

Line 204: from pay_shadow_balance_types sbt

200: -- (template_type = 'T').
201: --
202: cursor csr_T_balance_name_exists is
203: select null
204: from pay_shadow_balance_types sbt
205: where sbt.template_id = p_template_id
206: and upper(nvl(sbt.balance_name, hr_api.g_varchar2)) =
207: upper(nvl(p_balance_name, hr_api.g_varchar2));
208: --

Line 214: from pay_shadow_balance_types sbt

210: -- (template type = 'U').
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'

Line 540: from pay_shadow_balance_types sbt

536: l_api_updating boolean;
537: --
538: Cursor csr_chk_template is
539: select null
540: from pay_shadow_balance_types sbt
541: where sbt.balance_type_id = p_base_balance_type_id
542: and sbt.template_id = p_template_id;
543: --
544: Cursor csr_base_balances is

Line 546: from pay_shadow_balance_types

542: and sbt.template_id = p_template_id;
543: --
544: Cursor csr_base_balances is
545: select base_balance_type_id
546: from pay_shadow_balance_types
547: start with balance_type_id = p_base_balance_type_id
548: connect by prior base_balance_type_id = balance_type_id
549: ;
550: Begin

Line 690: from pay_shadow_balance_types sbt

686: and tco.shadow_object_id = p_balance_type_id;
687: --
688: cursor csr_balance_types is
689: select null
690: from pay_shadow_balance_types sbt
691: where sbt.base_balance_type_id = p_balance_type_id;
692: --
693: cursor csr_balance_feeds is
694: select null