DBA Data[Home] [Help]

APPS.HR_COST dependencies on PAY_RUN_RESULT_VALUES

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

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

Line 93: from pay_run_result_values prrv,

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