DBA Data[Home] [Help]

APPS.PAY_RUN_RESULT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 98: pay_element_entry_values_f peev

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
102: and peev.effective_end_date

Line 115: l_jurisdiction_eev_id pay_element_entry_values_f.element_entry_value_id%type;

111: l_output_currency_code pay_element_types_f.output_currency_code%type;
112: l_run_result_id pay_run_results.run_result_id%type;
113: l_amount pay_run_result_values.result_value%type;
114: l_rr_status pay_run_results.status%type;
115: l_jurisdiction_eev_id pay_element_entry_values_f.element_entry_value_id%type;
116: l_original_entry_id number;
117: l_rr_source_id number;
118: l_currency_type varchar2(30);
119: l_rr_sparse varchar2(10);

Line 184: from pay_element_entry_values_f eev,

180: select eev.screen_entry_value,
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