501: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
502: l_payroll_value VARCHAR2(80);
503: l_next_change_date per_pay_proposals.change_date%TYPE;
504: l_Entry_End_Date pay_element_entries_f.effective_end_date%TYPE;
505: l_pay_basis per_pay_bases.pay_basis%TYPE;
506: --
507: --
508: cursor csr_get_element_detail is
509: select pet.element_type_id,
512: ppb.pay_basis
513: from
514: pay_element_types_f pet,
515: pay_input_values_f piv,
516: per_pay_bases ppb,
517: per_all_assignments_f asg
518:
519: where
520: pet.element_type_id = piv.element_type_id