DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_GROSSUP_BAL_EXCLUSIONS

Line 631: from pay_grossup_bal_exclusions gbe

627: pir.effective_start_date and pir.effective_end_date;
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;

Line 792: l_table := 'PAY_GROSSUP_BAL_EXCLUSIONS';

788: raise l_error;
789: end if;
790: close csr_sir_exists;
791: elsif p_core_object_type = pay_tco_shd.g_sgb_lookup_type then
792: l_table := 'PAY_GROSSUP_BAL_EXCLUSIONS';
793: open csr_sgb_exists;
794: fetch csr_sgb_exists into l_exists;
795: if csr_sgb_exists%notfound then
796: close csr_sgb_exists;