APPS.PAY_FR_DB_PAY_SETUP dependencies on PAY_INPUT_VALUES_F

Line 638: insert into pay_input_values_f

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,

Line 691: insert into pay_input_values_f_tl

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,

Line 1539: from pay_input_values_f piv

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

Line 1541: , pay_input_values_f_tl pivtl

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