784:
785: cursor c_bases_element (cp_pay_basis_id in number,
786: cp_period_to_date in date) is
787: select piv.element_type_id, piv.input_value_id
788: from pay_input_values_f piv,
789: per_pay_bases ppb
790: where ppb.pay_basis_id = cp_pay_basis_id
791: and ppb.input_value_id = piv.input_value_id
792: and cp_period_to_date between piv.effective_start_date
797: cp_period_to_date in date ) is
798: select prrv.result_value
799: from pay_run_results prr,
800: pay_run_result_values prrv,
801: pay_input_values_f piv,
802: pay_assignment_actions paa,
803: pay_payroll_actions ppa
804: where prr.element_type_id = piv.element_type_id
805: and prr.run_result_id = prrv.run_result_id
819: cp_period_to_date in date ) is
820: select prrv.result_value
821: from pay_run_results prr,
822: pay_run_result_values prrv,
823: pay_input_values_f piv,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa
826: where prr.element_type_id = piv.element_type_id
827: and prr.run_result_id = prrv.run_result_id