DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 569: from pay_element_types_f et

565: and db.business_group_id = p_business_group_id;
566: --
567: cursor csr_set_exists is
568: select null
569: from pay_element_types_f et
570: where et.element_type_id = p_core_object_id
571: and et.business_group_id = p_business_group_id
572: and p_effective_date between
573: et.effective_start_date and et.effective_end_date;

Line 720: l_table := 'PAY_ELEMENT_TYPES_F';

716: end if;
717: close csr_sdb_exists;
718: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type
719: then
720: l_table := 'PAY_ELEMENT_TYPES_F';
721: open csr_set_exists;
722: fetch csr_set_exists into l_exists;
723: if csr_set_exists%notfound then
724: close csr_set_exists;