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 1193: l_assessed_ri pay_run_result_values.result_value%TYPE;

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

Line 1198: pay_run_result_values prrv

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