APPS.PQP_GB_PSI_WPS_HISTORY dependencies on PAY_ELEMENT_ENTRIES_F

Line 550: FROM PAY_ELEMENT_ENTRIES_F

546:
547: CURSOR csr_get_ele_end_date (c_element_entry_id NUMBER)
548: IS
549: SELECT max(effective_end_date)
550: FROM PAY_ELEMENT_ENTRIES_F
551: WHERE element_entry_id = c_element_entry_id;
552:
553: BEGIN
554:

Line 779: IF (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'

775: l_element_entry_id := l_chg_surrogate_key;
776: END IF;
777:
778: --Bug 7611963: Add chk for reverse terminations
779: IF (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
780: AND l_chg_column_name = 'EFFECTIVE_END_DATE'
781: AND l_update_type = 'E')
782: THEN
783: l_surrogate_key := g_pay_proc_evt_tab(l_curr_evt_index).surrogate_key;

Line 941: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F' or l_chg_table = 'PAY_ELEMENT_ENTRIES_F')

937: g_is_terminated := 'Y'; -- change termination status to 'Y'
938: debug('Salary Ended Today');
939:
940: -- For Bug 6033545
941: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F' or l_chg_table = 'PAY_ELEMENT_ENTRIES_F')
942: AND l_chg_column_name = 'EFFECTIVE_END_DATE'
943: THEN
944: l_return := 'N';
945: END IF;