DBA Data[Home] [Help]

APPS.PAY_DB_PAY_US_GROSS dependencies on PAY_INPUT_VALUES_F_TL

Line 278: FROM pay_input_values_f_tl piv_tl,

274: v_piv_name := hr_input_values.get_pay_value_name ('US');
275: --
276: SELECT piv.input_value_id
277: INTO v_input_value_ID
278: FROM pay_input_values_f_tl piv_tl,
279: pay_input_values_f piv,
280: pay_element_types_f_tl pet_tl,
281: pay_element_types_f pet
282: WHERE piv_tl.input_value_id = piv.input_value_id

Line 311: FROM pay_input_values_f_tl piv_tl,

307: -- for the FIT_GROSSUP_ADJUSTMENT element.
308: --
309: SELECT piv.input_value_id
310: INTO v_input_value_ID
311: FROM pay_input_values_f_tl piv_tl,
312: pay_input_values_f piv,
313: pay_element_types_f pet
314: WHERE piv_tl.input_value_id = piv.input_value_id
315: and userenv('LANG') = piv_tl.language