DBA Data[Home] [Help]

APPS.PY_ZA_TX_01032013 dependencies on PER_TIME_PERIODS

Line 357: , per_time_periods ptp

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

Line 358: , per_time_periods ptp_all

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

Line 4306: , per_time_periods ptp

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

Line 4307: , per_time_periods ptp_all

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