APPS.PAY_DB_PAY_US_GROSS dependencies on PAY_INPUT_VALUES_F

Line 178: v_piv_name PAY_INPUT_VALUES_F.NAME%TYPE;

174: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
175: v_input_value_ID NUMBER;
176: v_start_date DATE;
177: v_end_date DATE;
178: v_piv_name PAY_INPUT_VALUES_F.NAME%TYPE;
179: --
180: begin
181: --
182: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 1);

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 279: pay_input_values_f piv,

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
283: and pet_tl.element_type_id = pet.element_type_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

Line 312: pay_input_values_f piv,

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
316: and piv_tl.name = v_piv_name