APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_RUN_RESULTS

Line 392: pay_run_results pr,

388: --
389: cursor result_type_value(p_piv_id NUMBER, p_assig_act_id NUMBER) is
390: SELECT result_value
391: FROM pay_run_result_values prr,
392: pay_run_results pr,
393: pay_element_types_f pet,
394: pay_input_values_f piv
395: WHERE pr.assignment_action_id = p_assig_act_id
396: and pr.element_type_id = pet.element_type_id

Line 410: from pay_run_results pr1

406: and to_date(p_date_earned, 'YYYY/MM/DD')
407: between pet.effective_start_date
408: and pet.effective_end_date
409: and pr.run_result_id = (select nvl(max(pr1.run_result_id),pr.run_result_id)
410: from pay_run_results pr1
411: where pr1.assignment_action_id = p_assig_act_id
412: and pr1.element_type_id = pr.element_type_id
413: and pr1.status = 'P');
414: