APPS.PAY_RUN_RESULT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 109: l_entry_type pay_element_entries_f.entry_type%type;

105: --
106: l_jurisdiction_code pay_run_results.jurisdiction_code%type;
107: l_assignment_id per_assignments_f.assignment_id%type;
108: l_element_type_id pay_element_types_f.element_type_id%type;
109: l_entry_type pay_element_entries_f.entry_type%type;
110: l_input_currency_code pay_element_types_f.input_currency_code%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;

Line 154: from pay_element_entries_f ee,

150: l_run_result_id,
151: l_local_unit_id,
152: l_time_definition_type,
153: l_s_time_definition_id
154: from pay_element_entries_f ee,
155: pay_element_types_f et
156: where ee.element_entry_id = p_element_entry_id
157: and et.element_type_id = ee.element_type_id
158: and p_session_date between ee.effective_start_date

Line 186: pay_element_entries_f pee

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
190: and piv.name = p_jc_name

Line 411: l_entry_type pay_element_entries_f.entry_type%type;

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: --
411: l_entry_type pay_element_entries_f.entry_type%type;
412: l_run_result_id pay_run_results.run_result_id%type;
413: l_entry_id pay_run_results.source_id%type;
414: l_rr_status pay_run_results.status%type;
415: l_local_unit_id number;