APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 177: pay_run_result_values prrv,

173: IS
174: SELECT fnd_number.canonical_to_number(prrv.result_value)
175: FROM pay_assignment_actions paa,
176: pay_run_results prr,
177: pay_run_result_values prrv,
178: pay_input_values_f pivf
179: WHERE prr.run_result_id = c_run_result_id
180: AND paa.assignment_action_id = c_assignment_action_id
181: AND prr.run_result_id = prrv.run_result_id

Line 187: l_result_value pay_run_result_values.result_value%TYPE;

183: AND pivf.legislation_code = 'HK'
184: AND pivf.name = 'Source'
185: AND prr.assignment_action_id = paa.assignment_action_id;
186: --
187: l_result_value pay_run_result_values.result_value%TYPE;
188: BEGIN
189: l_result_value := null; -- Bug: 3604131
190: --
191: IF g_debug THEN

Line 1192: l_assessed_ri pay_run_result_values.result_value%TYPE;

1188:
1189: FUNCTION get_assessed_ri(p_run_result_id in pay_run_results.run_result_id%TYPE)
1190: RETURN VARCHAR2 IS
1191:
1192: l_assessed_ri pay_run_result_values.result_value%TYPE;
1193: CURSOR csr_get_accessed_ri
1194: IS
1195: SELECT prrv.result_value
1196: FROM pay_input_values_f pivf,

Line 1197: pay_run_result_values prrv

1193: CURSOR csr_get_accessed_ri
1194: IS
1195: SELECT prrv.result_value
1196: FROM pay_input_values_f pivf,
1197: pay_run_result_values prrv
1198: WHERE prrv.run_result_id = p_run_result_id
1199: AND pivf.input_value_id = prrv.input_value_id
1200: AND pivf.name = 'Assessed RI';
1201: BEGIN