APPS.PAY_TCO_BUS dependencies on PAY_ELEMENT_TYPE_USAGES_F

Line 639: from pay_element_type_usages_f etu

635: and pbt.business_group_id = p_business_group_id;
636: --
637: cursor csr_seu_exists is
638: select null
639: from pay_element_type_usages_f etu
640: where etu.business_group_id = p_business_group_id
641: and etu.element_type_usage_id = p_core_object_id
642: and p_effective_date between
643: etu.effective_start_date and etu.effective_end_date;

Line 801: l_table := 'PAY_ELEMENT_TYPE_USAGES_F';

797: raise l_error;
798: end if;
799: close csr_sgb_exists;
800: elsif p_core_object_type = pay_tco_shd.g_seu_lookup_type then
801: l_table := 'PAY_ELEMENT_TYPE_USAGES_F';
802: open csr_seu_exists;
803: fetch csr_seu_exists into l_exists;
804: if csr_seu_exists%notfound then
805: close csr_seu_exists;