DBA Data[Home] [Help]

APPS.HR_COST dependencies on PAY_RUN_RESULT_VALUES

Line 88: cnt_value varchar2(60); --pay_run_result_values.result_value%type;

84: p_run_result_id in number,
85: p_element_type_id in number,
86: p_eff_date in date
87: ) return varchar2 is
88: cnt_value varchar2(60); --pay_run_result_values.result_value%type;
89: --
90: BEGIN
91:
92: select prrv.result_value

Line 94: from pay_run_result_values prrv,

90: BEGIN
91:
92: select prrv.result_value
93: into cnt_value
94: from pay_run_result_values prrv,
95: pay_input_values_f piv
96: where prrv.run_result_id = p_run_result_id
97: and piv.name = p_inp_val_name
98: and piv.input_value_id = prrv.input_value_id