APPS.PAY_RUN_RESULT_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 20: l_result_value pay_run_result_values.result_value%type;

16: p_business_group_id in number
17: ) return varchar2
18: is
19: --
20: l_result_value pay_run_result_values.result_value%type;
21: l_legislation_code per_business_groups.legislation_code%type;
22: l_inp_val_name pay_input_values_f.name%type;
23: l_found boolean;
24: --

Line 30: from pay_run_result_values

26: begin
27: --
28: select result_value
29: into l_result_value
30: from pay_run_result_values
31: where run_result_id = p_run_result_id
32: and input_value_id = p_input_value_id;
33: --
34: return l_result_value;

Line 113: l_amount pay_run_result_values.result_value%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;
117: l_rr_source_id number;

Line 354: insert into pay_run_result_values

350: end if;
351: --
352: if (save_value = TRUE) then
353: --
354: insert into pay_run_result_values
355: (input_value_id,
356: run_result_id,
357: result_value,
358: formula_result_flag)

Line 509: insert into pay_run_result_values

505: end if;
506: --
507: if (save_value = TRUE) then
508: --
509: insert into pay_run_result_values
510: (input_value_id,
511: run_result_id,
512: result_value,
513: formula_result_flag)

Line 591: from pay_run_result_values

587: begin
588: --
589: select 1
590: into l_dummy
591: from pay_run_result_values
592: where run_result_id = p_run_result_id
593: and input_value_id = p_input_value_id;
594: --
595: update pay_run_result_values

Line 595: update pay_run_result_values

591: from pay_run_result_values
592: where run_result_id = p_run_result_id
593: and input_value_id = p_input_value_id;
594: --
595: update pay_run_result_values
596: set result_value = p_value,
597: formula_result_flag = p_formula_result_flag
598: where run_result_id = p_run_result_id
599: and input_value_id = p_input_value_id;

Line 604: insert into pay_run_result_values

600: --
601: exception
602: when no_data_found then
603: --
604: insert into pay_run_result_values
605: (input_value_id,
606: run_result_id,
607: result_value,
608: formula_result_flag)