353: select distinct dirnum from (
354: SELECT process.result_value dirnum
355: FROM pay_assignment_actions paa
356: , pay_payroll_actions ppa
357: , per_time_periods ptp
358: , per_time_periods ptp_all
359: , pay_assignment_actions paa_all
360: , pay_payroll_actions ppa_all
361: , pay_run_results prr_ls
354: SELECT process.result_value dirnum
355: FROM pay_assignment_actions paa
356: , pay_payroll_actions ppa
357: , per_time_periods ptp
358: , per_time_periods ptp_all
359: , pay_assignment_actions paa_all
360: , pay_payroll_actions ppa_all
361: , pay_run_results prr_ls
362: , pay_run_result_values target
4302: cursor csr_all_LSDir(p_ass_action_id in number ) is
4303: SELECT process.result_value dirnum
4304: FROM pay_assignment_actions paa
4305: , pay_payroll_actions ppa
4306: , per_time_periods ptp
4307: , per_time_periods ptp_all
4308: , pay_assignment_actions paa_all
4309: , pay_payroll_actions ppa_all
4310: , pay_run_results prr_ls
4303: SELECT process.result_value dirnum
4304: FROM pay_assignment_actions paa
4305: , pay_payroll_actions ppa
4306: , per_time_periods ptp
4307: , per_time_periods ptp_all
4308: , pay_assignment_actions paa_all
4309: , pay_payroll_actions ppa_all
4310: , pay_run_results prr_ls
4311: , pay_run_result_values target