DBA Data[Home] [Help]

APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 815: from pay_element_entries_f pee, pay_element_type_extra_info petei

811:
812: cursor csr_check_dup_allow_types
813: is
814: select 1
815: from pay_element_entries_f pee, pay_element_type_extra_info petei
816: where pee.assignment_id = p_assignment_id
817: and pee.element_type_id = petei.element_type_id
818: and p_effective_date between pee.effective_start_date and pee.effective_end_date
819: and pee.element_entry_id <> PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id