DBA Data[Home] [Help]

APPS.PAY_RUN_RESULT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 108: l_element_type_id pay_element_types_f.element_type_id%type;

104: and piv.effective_end_date;
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;

Line 110: l_input_currency_code pay_element_types_f.input_currency_code%type;

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;
114: l_rr_status pay_run_results.status%type;

Line 111: l_output_currency_code pay_element_types_f.output_currency_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;
114: l_rr_status pay_run_results.status%type;
115: l_jurisdiction_eev_id pay_element_entry_values_f.element_entry_value_id%type;

Line 122: l_time_definition_type pay_element_types_f.time_definition_type%type;

118: l_currency_type varchar2(30);
119: l_rr_sparse varchar2(10);
120: l_local_unit_id number;
121: save_value boolean;
122: l_time_definition_type pay_element_types_f.time_definition_type%type;
123: l_time_definition_id pay_run_results.time_definition_id%type;
124: l_s_time_definition_id pay_run_results.time_definition_id%type;
125: l_time_def_start_date per_time_periods.start_date%type;
126: l_time_def_end_date per_time_periods.end_date%type;

Line 155: pay_element_types_f et

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
159: and ee.effective_end_date