[Home] [Help]
5046: bg_id number
5047: ) is
5048: select eev.screen_entry_value screen_entry_value,
5049: ele.element_entry_id
5050: from pay_element_types_f elt,
5051: pay_input_values_f ipv,
5052: pay_element_entries_f ele,
5053: pay_element_entry_values_f eev
5054: where trunc(eff_date)
5104:
5105: Cursor Cur_Sal_Basis_name(p_bg_id NUMBER,p_ele_name VARCHAR2)
5106: IS
5107: Select pb.pay_basis_id
5108: From pay_element_types_f ele,
5109: pay_input_values_f inp,
5110: per_pay_bases pb
5111: where ele.business_group_id=p_bg_id
5112: and upper(element_name)=upper(p_ele_name)
5263:
5264: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5265: -----GPPA Update46 End.
5266:
5267: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5268: c_effective_date pay_element_entries_f.effective_start_date%type,
5269: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5270: SELECT 1
5271: FROM pay_element_entries_f pee, pay_element_types_f pet
5267: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5268: c_effective_date pay_element_entries_f.effective_start_date%type,
5269: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5270: SELECT 1
5271: FROM pay_element_entries_f pee, pay_element_types_f pet
5272: WHERE pee.element_type_id = pet.element_type_id
5273: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
5274: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
5275: AND pet.element_name = c_element_name
6973: ipv.input_value_id,
6974: ipv.uom,
6975: eev.screen_entry_value screen_entry_value,
6976: ele.object_version_number
6977: from pay_element_types_f elt,
6978: pay_input_values_f ipv,
6979: pay_element_entries_f ele,
6980: pay_element_entry_values_f eev
6981: where trunc(eff_date) between elt.effective_start_date