1551: select ppb.name
1552: into lv_salary_basis
1553: from pay_element_types_f pet,
1554: pay_input_values_f piv,
1555: per_pay_bases ppb
1556: where ppb.pay_basis_id=ln_pay_basis_id
1557: and ppb.input_value_id=piv.input_value_id
1558: and ld_effective_date between
1559: piv.effective_start_date and