APPS.PAY_DB_PAY_SETUP dependencies on PAY_INPUT_VALUES_F

Line 428: v_jurisdiction pay_input_values_f.name%TYPE;

424: v_session_date date;
425: v_effective_start_date date;
426: v_effective_end_date date;
427: v_uom varchar2(240);
428: v_jurisdiction pay_input_values_f.name%TYPE;
429: v_warning_or_error varchar2(240);
430: v_rowid VARCHAR2(240);
431: v_base_language varchar2(240);
432: --

Line 642: insert into pay_input_values_f

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

Line 716: insert into pay_input_values_f_tl

712: end;
713: hr_utility.trace('v_jurisdiction@@@@@@@@@@: '||v_jurisdiction);
714:
715: --
716: insert into pay_input_values_f_tl
717: (INPUT_VALUE_ID,
718: NAME,
719: LANGUAGE,
720: SOURCE_LANG,

Line 1564: from pay_input_values_f piv

1560: ,p_ctl_leg varchar2)
1561: is
1562: select piv.input_value_id
1563: , pet.element_type_id
1564: from pay_input_values_f piv
1565: , pay_element_types_f pet
1566: , pay_input_values_f_tl pivtl
1567: , pay_element_types_f_tl pettl
1568: where piv.input_value_id = pivtl.input_value_id

Line 1566: , pay_input_values_f_tl pivtl

1562: select piv.input_value_id
1563: , pet.element_type_id
1564: from pay_input_values_f piv
1565: , pay_element_types_f pet
1566: , pay_input_values_f_tl pivtl
1567: , pay_element_types_f_tl pettl
1568: where piv.input_value_id = pivtl.input_value_id
1569: and pivtl.language = userenv('LANG')
1570: and pivtl.name = p_prim_iv