359: select distinct dirnum from (
360: SELECT process.result_value dirnum
361: FROM pay_assignment_actions paa
362: , pay_payroll_actions ppa
363: , per_time_periods ptp
364: , per_time_periods ptp_all
365: , pay_assignment_actions paa_all
366: , pay_payroll_actions ppa_all
367: , pay_run_results prr_ls
360: SELECT process.result_value dirnum
361: FROM pay_assignment_actions paa
362: , pay_payroll_actions ppa
363: , per_time_periods ptp
364: , per_time_periods ptp_all
365: , pay_assignment_actions paa_all
366: , pay_payroll_actions ppa_all
367: , pay_run_results prr_ls
368: , pay_run_result_values target
7217: cursor csr_all_LSDir(p_ass_action_id in number ) is
7218: SELECT /*+ use_nl ( ptp_all ppa_all feed)*/ process.result_value dirnum
7219: FROM pay_assignment_actions paa
7220: , pay_payroll_actions ppa
7221: , per_time_periods ptp
7222: , per_time_periods ptp_all
7223: , pay_assignment_actions paa_all
7224: , pay_payroll_actions ppa_all
7225: , pay_run_results prr_ls
7218: SELECT /*+ use_nl ( ptp_all ppa_all feed)*/ process.result_value dirnum
7219: FROM pay_assignment_actions paa
7220: , pay_payroll_actions ppa
7221: , per_time_periods ptp
7222: , per_time_periods ptp_all
7223: , pay_assignment_actions paa_all
7224: , pay_payroll_actions ppa_all
7225: , pay_run_results prr_ls
7226: , pay_run_result_values target