APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_RUN_RESULTS

Line 384: pay_run_results pr,

380: --
381: cursor result_type_value(p_piv_id NUMBER, p_assig_act_id NUMBER) is
382: SELECT result_value
383: FROM pay_run_result_values prr,
384: pay_run_results pr,
385: pay_element_types_f pet,
386: pay_input_values_f piv
387: WHERE pr.assignment_action_id = p_assig_act_id
388: and pr.element_type_id = pet.element_type_id

Line 402: from pay_run_results pr1

398: and to_date(p_date_earned, 'YYYY/MM/DD')
399: between pet.effective_start_date
400: and pet.effective_end_date
401: and pr.run_result_id = (select nvl(max(pr1.run_result_id),pr.run_result_id)
402: from pay_run_results pr1
403: where pr1.assignment_action_id = p_assig_act_id
404: and pr1.element_type_id = pr.element_type_id
405: and pr1.status = 'P');
406: