APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PAY_ELEMENT_ENTRIES_F

Line 492: From PAY_ELEMENT_ENTRIES_F

488: --For bug 7158117: Added new cursor
489: Cursor csr_get_ele_end_date (c_element_entry_id number)
490: IS
491: Select max(effective_end_date)
492: From PAY_ELEMENT_ENTRIES_F
493: Where element_entry_id = c_element_entry_id;
494:
495: l_surrogate_key NUMBER;
496: l_ele_end_date DATE;

Line 621: IF (l_chg_table_name = 'PAY_ELEMENT_ENTRIES_F'

617: return l_return;
618: END IF;
619:
620: --For bug 7158117: Added condn to supress end date record
621: IF (l_chg_table_name = 'PAY_ELEMENT_ENTRIES_F'
622: AND l_chg_column_name = 'EFFECTIVE_END_DATE'
623: AND l_update_type = 'E')
624: THEN
625: l_surrogate_key := g_pay_proc_evt_tab(l_curr_evt_index).surrogate_key;

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