[Home] [Help]
481: --Cursor to get allowance code of current Allowance element
482: CURSOR csr_curr_ele_allow_code
483: IS
484: Select info.eei_information2
485: From pay_element_entries_f ent,
486: pay_element_type_extra_info info
487: Where info.eei_information_category = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
488: and info.element_type_id = ent.element_type_id
489: and ent.element_entry_id = p_element_entry_id
492: --Cursor to get the element attached on the following day
493: CURSOR csr_get_new_ele
494: IS
495: Select element_type_id
496: From pay_element_entries_f
497: Where assignment_id = p_assignment_id
498: and effective_start_date = p_eve_eff_date+1;
499:
500: --Cursor to check if the new element is an allownance element and having a same
620: --For bug 7158117: Added new cursor
621: Cursor csr_get_ele_end_date (c_element_entry_id number)
622: IS
623: Select max(effective_end_date)
624: From PAY_ELEMENT_ENTRIES_F
625: Where element_entry_id = c_element_entry_id;
626:
627: l_surrogate_key NUMBER;
628: l_ele_end_date DATE;
749: return l_return;
750: END IF;
751:
752: --For bug 7158117: Added condn to supress end date record
753: IF (l_chg_table_name = 'PAY_ELEMENT_ENTRIES_F'
754: AND l_chg_column_name = 'EFFECTIVE_END_DATE'
755: AND l_update_type = 'E')
756: THEN
757: l_surrogate_key := g_pay_proc_evt_tab(l_curr_evt_index).surrogate_key;
956:
957: cursor csr_check_dup_allow_types
958: is
959: select 1
960: from pay_element_entries_f pee, pay_element_type_extra_info petei
961: where pee.assignment_id = p_assignment_id
962: and pee.element_type_id = petei.element_type_id
963: and p_effective_date between pee.effective_start_date and pee.effective_end_date
964: and pee.element_entry_id <> PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id