APPS.BEN_ELEMENT_ENTRY dependencies on PAY_INPUT_VALUES_F

Line 429: pay_input_values_f piv

425: eiv.input_text,
426: eiv.return_var_name,
427: eiv.upd_when_ele_ended_cd
428: from ben_extra_input_values eiv,
429: pay_input_values_f piv
430: where eiv.acty_base_rt_id = p_acty_base_rt_id
431: and eiv.business_group_id = p_business_group_id
432: and piv.input_value_id = eiv.input_value_id
433: and p_effective_date between piv.effective_start_date

Line 456: from pay_input_values_f

452: ler.effective_start_date and ler.effective_end_date;
453: --
454: cursor c_inp_name is
455: select upper(replace(name,' ','_'))
456: from pay_input_values_f
457: where input_value_id = p_input_value_id1
458: and p_effective_date between
459: effective_start_date and effective_end_date;
460:

Line 466: l_inp_name pay_input_values_f.name%type;

462: --
463: l_param_tab ff_exec.outputs_t;
464: l_ext_inpval_tab ext_inpval_tab_typ;
465: l_counter number;
466: l_inp_name pay_input_values_f.name%type;
467: l_proc varchar2(72) := g_package||' get_extra_ele_inputs';
468:
469: procedure populate_param_tab
470: (p_name in varchar2,

Line 779: from pay_element_entry_values_f peev, pay_input_values_f piv

775: cursor c_inpval is
776: select peev.input_value_id,
777: peev.screen_entry_value,
778: piv.UOM
779: from pay_element_entry_values_f peev, pay_input_values_f piv
780: where peev.element_entry_id = p_element_entry_id
781: and p_effective_date between peev.effective_start_date and peev.effective_end_date
782: and piv.input_value_id = peev.input_value_id
783: and p_effective_date between piv.effective_start_date and piv.effective_end_date;