eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_RUN_RESULT_PKG dependencies on PAY_RUN_RESULTS

Line 106: l_jurisdiction_code pay_run_results.jurisdiction_code%type;

102: and peev.effective_end_date
103: and p_session_date between piv.effective_start_date
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;

Line 112: l_run_result_id pay_run_results.run_result_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;
116: l_original_entry_id number;

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 123: l_time_definition_id pay_run_results.time_definition_id%type;

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;
127: begin

Line 124: l_s_time_definition_id pay_run_results.time_definition_id%type;

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;
127: begin
128: --

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 249: insert into pay_run_results

245:
246:
247: begin
248: --
249: insert into pay_run_results
250: (run_result_id,
251: element_type_id,
252: assignment_action_id,
253: entry_type,

Line 412: l_run_result_id pay_run_results.run_result_id%type;

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;
416: save_value boolean;

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 417: l_time_definition_id pay_run_results.time_definition_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;
419: l_end_date pay_run_results.end_date%type;
420: --
421: begin

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 419: l_end_date pay_run_results.end_date%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
423: --

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 438: from pay_run_results prr

434: l_local_unit_id,
435: l_time_definition_id,
436: l_start_date,
437: l_end_date
438: from pay_run_results prr
439: where prr.run_result_id = p_run_result_id;
440: --
441: exception
442: when NO_DATA_FOUND then

Line 461: insert into pay_run_results

457: -- #4482023. Time Definition has to be stamped on indirect run results
458: -- when the parent results has the time definition.
459: --
460:
461: insert into pay_run_results
462: (run_result_id,
463: element_type_id,
464: assignment_action_id,
465: entry_type,

Line 561: update pay_run_results

557: --
558: /* Set the jurisdiction value on the RR if needed */
559: if (l_iv_name = p_jc_name) then
560: --
561: update pay_run_results
562: set jurisdiction_code = p_value
563: where run_result_id = p_run_result_id;
564: --
565: end if;

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

Line 643: insert into pay_run_results

639: select pay_run_results_s.nextval
640: into l_run_result_id
641: from dual;
642: --
643: insert into pay_run_results
644: (run_result_id,
645: element_type_id,
646: assignment_action_id,
647: entry_type,