APPS.PAY_DB_PAY_SETUP dependencies on PAY_INPUT_VALUES_F

Line 640: insert into pay_input_values_f

636: end if;
637: --
638: -- Create input value
639: --
640: insert into pay_input_values_f
641: (INPUT_VALUE_ID,
642: EFFECTIVE_START_DATE,
643: EFFECTIVE_END_DATE,
644: ELEMENT_TYPE_ID,

Line 693: insert into pay_input_values_f_tl

689: v_todays_date);
690: --
691: for lang_rec in c_installed_language loop
692: --
693: insert into pay_input_values_f_tl
694: (INPUT_VALUE_ID,
695: NAME,
696: LANGUAGE,
697: SOURCE_LANG,

Line 1541: from pay_input_values_f piv

1537: ,p_ctl_leg varchar2)
1538: is
1539: select piv.input_value_id
1540: , pet.element_type_id
1541: from pay_input_values_f piv
1542: , pay_element_types_f pet
1543: , pay_input_values_f_tl pivtl
1544: , pay_element_types_f_tl pettl
1545: where piv.input_value_id = pivtl.input_value_id

Line 1543: , pay_input_values_f_tl pivtl

1539: select piv.input_value_id
1540: , pet.element_type_id
1541: from pay_input_values_f piv
1542: , pay_element_types_f pet
1543: , pay_input_values_f_tl pivtl
1544: , pay_element_types_f_tl pettl
1545: where piv.input_value_id = pivtl.input_value_id
1546: and pivtl.language = userenv('LANG')
1547: and pivtl.name = p_prim_iv