APPS.HR_PAY_BASIS dependencies on PAY_INPUT_VALUES_F

Line 228: pay_input_values_f piv

224: FROM sys.dual
225: WHERE EXISTS
226: (select 'Y'
227: from per_pay_bases ppb,
228: pay_input_values_f piv
229: where piv.element_type_id = p_element_type_id
230: and ppb.input_value_id = piv.input_value_id
231: and (p_row_id <> ppb.rowid
232: or p_row_id is null)

Line 381: from pay_input_values_f piv,

377: pet.element_type_id
378: into p_iv_name,
379: p_element_name,
380: p_element_type_id
381: from pay_input_values_f piv,
382: pay_input_values_f_tl pivtl,
383: pay_element_types_f pet,
384: pay_element_types_f_tl pettl
385: where pet.element_type_id = piv.element_type_id

Line 382: pay_input_values_f_tl pivtl,

378: into p_iv_name,
379: p_element_name,
380: p_element_type_id
381: from pay_input_values_f piv,
382: pay_input_values_f_tl pivtl,
383: pay_element_types_f pet,
384: pay_element_types_f_tl pettl
385: where pet.element_type_id = piv.element_type_id
386: and pet.element_type_id = pettl.element_type_id

Line 453: from pay_input_values_f

449: select min(effective_start_date),
450: max(effective_end_date)
451: into p_start_date,
452: p_end_date
453: from pay_input_values_f
454: where input_value_id = p_input_value_id;
455: --
456: exception
457: when NO_DATA_FOUND

Line 497: from pay_input_values_f

493: into v_valid
494: from sys.dual
495: where exists
496: (select 1
497: from pay_input_values_f
498: where input_value_id = p_input_value_id
499: and p_session_date between effective_start_date
500: and effective_end_date);
501: --