APPS.PAY_RUN_RESULT_PKG dependencies on PAY_INPUT_VALUES_F

Line 22: l_inp_val_name pay_input_values_f.name%type;

18: is
19: --
20: l_result_value pay_run_result_values.result_value%type;
21: l_legislation_code per_business_groups.legislation_code%type;
22: l_inp_val_name pay_input_values_f.name%type;
23: l_found boolean;
24: --
25: begin
26: begin

Line 97: from pay_input_values_f piv,

93: select peev.input_value_id,
94: piv.uom,
95: peev.screen_entry_value value,
96: peev.element_entry_value_id
97: from pay_input_values_f piv,
98: pay_element_entry_values_f peev
99: where peev.element_entry_id = p_element_entry_id
100: and piv.input_value_id = peev.input_value_id
101: and p_session_date between peev.effective_start_date

Line 185: pay_input_values_f piv,

181: eev.element_entry_value_id
182: into l_jurisdiction_code,
183: l_jurisdiction_eev_id
184: from pay_element_entry_values_f eev,
185: pay_input_values_f piv,
186: pay_element_entries_f pee
187: where pee.element_entry_id = p_element_entry_id
188: and eev.element_entry_id = pee.element_entry_id
189: and eev.input_value_id = piv.input_value_id

Line 406: from pay_input_values_f piv

402: p_effdate date)
403: is
404: select piv.input_value_id,
405: piv.name
406: from pay_input_values_f piv
407: where piv.element_type_id = p_et_id
408: and p_effdate between piv.effective_start_date
409: and piv.effective_end_date;
410: --

Line 546: l_iv_name pay_input_values_f.name%type;

542: p_mode in varchar2
543: )
544: is
545: --
546: l_iv_name pay_input_values_f.name%type;
547: save_value boolean;
548: --
549: begin
550: --

Line 553: from pay_input_values_f

549: begin
550: --
551: select name
552: into l_iv_name
553: from pay_input_values_f
554: where input_value_id = p_input_value_id
555: and p_session_date between effective_start_date
556: and effective_end_date;
557: --