APPS.PAY_RUN_RESULT_PKG dependencies on PAY_RUN_RESULTS_S

Line 114: l_rr_status pay_run_results.status%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;
116: l_original_entry_id number;
117: l_rr_source_id number;
118: l_currency_type varchar2(30);

Line 139: pay_run_results_s.nextval,

135: ee.entry_type,
136: ee.original_entry_id,
137: et.input_currency_code,
138: et.output_currency_code,
139: pay_run_results_s.nextval,
140: hr_dynsql.get_local_unit(ee.assignment_id,
141: p_session_date),
142: et.time_definition_type,
143: et.time_definition_id

Line 413: l_entry_id pay_run_results.source_id%type;

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;
416: save_value boolean;
417: l_time_definition_id pay_run_results.time_definition_id%type;

Line 414: l_rr_status pay_run_results.status%type;

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;
416: save_value boolean;
417: l_time_definition_id pay_run_results.time_definition_id%type;
418: l_start_date pay_run_results.start_date%type;

Line 418: l_start_date pay_run_results.start_date%type;

414: l_rr_status pay_run_results.status%type;
415: l_local_unit_id number;
416: save_value boolean;
417: l_time_definition_id pay_run_results.time_definition_id%type;
418: l_start_date pay_run_results.start_date%type;
419: l_end_date pay_run_results.end_date%type;
420: --
421: begin
422: begin

Line 426: pay_run_results_s.nextval,

422: begin
423: --
424: select prr.entry_type,
425: prr.source_id,
426: pay_run_results_s.nextval,
427: local_unit_id,
428: time_definition_id,
429: start_date,
430: end_date

Line 639: select pay_run_results_s.nextval

635: is
636: l_run_result_id number;
637: begin
638: --
639: select pay_run_results_s.nextval
640: into l_run_result_id
641: from dual;
642: --
643: insert into pay_run_results