DBA Data[Home] [Help]

APPS.PY_ZA_TX_01032012 dependencies on PER_TIME_PERIODS

Line 363: , per_time_periods ptp

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

Line 364: , per_time_periods ptp_all

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

Line 7221: , per_time_periods ptp

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

Line 7222: , per_time_periods ptp_all

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