634: end if;
635: --
636: -- Create input value
637: --
638: insert into pay_input_values_f
639: (INPUT_VALUE_ID,
640: EFFECTIVE_START_DATE,
641: EFFECTIVE_END_DATE,
642: ELEMENT_TYPE_ID,
687: v_todays_date);
688: --
689: for lang_rec in c_installed_language loop
690: --
691: insert into pay_input_values_f_tl
692: (INPUT_VALUE_ID,
693: NAME,
694: LANGUAGE,
695: SOURCE_LANG,
1535: ,p_ctl_leg varchar2)
1536: is
1537: select piv.input_value_id
1538: , pet.element_type_id
1539: from pay_input_values_f piv
1540: , pay_element_types_f pet
1541: , pay_input_values_f_tl pivtl
1542: , pay_element_types_f_tl pettl
1543: where piv.input_value_id = pivtl.input_value_id
1537: select piv.input_value_id
1538: , pet.element_type_id
1539: from pay_input_values_f piv
1540: , pay_element_types_f pet
1541: , pay_input_values_f_tl pivtl
1542: , pay_element_types_f_tl pettl
1543: where piv.input_value_id = pivtl.input_value_id
1544: and pivtl.language = userenv('LANG')
1545: and pivtl.name = p_prim_iv