550: AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;
551:
552: CURSOR c_input_values(p_element_entry_id IN NUMBER)
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
551:
552: CURSOR c_input_values(p_element_entry_id IN NUMBER)
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
552: CURSOR c_input_values(p_element_entry_id IN NUMBER)
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
561: pay_element_entry_values_f peevf2,