1468: --
1469: csr1_price_max number;
1470: csr1_ni_rate number;
1471: --
1472: csr2_element_name pay_element_types_f.element_name%type;
1473: csr2_pr number;
1474: csr2_rd number;
1475: csr2_rn number;
1476: csr2_mb number;
1552: , pay_input_values_f ICC
1553: , pay_input_values_f IFS
1554: , pay_input_values_f IAP
1555: , pay_input_values_f ICO
1556: , pay_element_types_f_tl E_TL
1557: , pay_element_types_f E
1558: WHERE E_TL.element_type_id = E.element_type_id
1559: AND E.element_type_id = p_element_type_id
1560: AND userenv('LANG') = E_TL.language
1553: , pay_input_values_f IFS
1554: , pay_input_values_f IAP
1555: , pay_input_values_f ICO
1556: , pay_element_types_f_tl E_TL
1557: , pay_element_types_f E
1558: WHERE E_TL.element_type_id = E.element_type_id
1559: AND E.element_type_id = p_element_type_id
1560: AND userenv('LANG') = E_TL.language
1561: AND IPR.element_type_id = E.element_type_id