APPS.PAY_TCO_BUS dependencies on PAY_BALANCE_TYPES

Line 557: from pay_balance_types bt

553: ff.effective_start_date and ff.effective_end_date;
554: --
555: cursor csr_sbt_exists is
556: select null
557: from pay_balance_types bt
558: where bt.balance_type_id = p_core_object_id
559: and bt.business_group_id = p_business_group_id;
560: --
561: cursor csr_sdb_exists is

Line 632: , pay_balance_types pbt

628: --
629: cursor csr_sgb_exists is
630: select null
631: from pay_grossup_bal_exclusions gbe
632: , pay_balance_types pbt
633: where gbe.grossup_balances_id = p_core_object_id
634: and gbe.balance_type_id = pbt.balance_type_id
635: and pbt.business_group_id = p_business_group_id;
636: --

Line 701: l_table := 'PAY_BALANCE_TYPES';

697: raise l_error;
698: end if;
699: close csr_sf_exists;
700: elsif p_core_object_type = pay_tco_shd.g_sbt_lookup_type then
701: l_table := 'PAY_BALANCE_TYPES';
702: open csr_sbt_exists;
703: fetch csr_sbt_exists into l_exists;
704: if csr_sbt_exists%notfound then
705: close csr_sbt_exists;