APPS.PY_ZA_TX_01032013 dependencies on PAY_PAYROLL_ACTIONS

Line 356: , pay_payroll_actions ppa

352: is
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

Line 360: , pay_payroll_actions ppa_all

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
363: , pay_balance_feeds_f feed
364: , pay_run_result_values process

Line 4305: , pay_payroll_actions ppa

4301:
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

Line 4309: , pay_payroll_actions ppa_all

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
4312: , pay_balance_feeds_f feed
4313: , pay_run_result_values process

Line 4377: ,pay_payroll_actions ppa

4373: -- Assignment Number
4374: SELECT paaf.assignment_number
4375: INTO l_assignment_number
4376: FROM per_all_assignments_f paaf
4377: ,pay_payroll_actions ppa
4378: WHERE paaf.assignment_id = ZaTx_01032013.ASSIGNMENT_ID
4379: AND ppa.payroll_action_id = ZaTx_01032013.PAYROLL_ACTION_ID
4380: AND ppa.effective_date
4381: BETWEEN paaf.effective_start_date

Line 5089: pay_payroll_actions PACT,

5085: from
5086: pay_balance_feeds_f FEED,
5087: pay_run_result_values TARGET,
5088: pay_run_results RR,
5089: pay_payroll_actions PACT,
5090: pay_assignment_actions ASSACT,
5091: pay_payroll_actions BACT,
5092: pay_assignment_actions BAL_ASSACT
5093: where FEED.BALANCE_TYPE_ID = (

Line 5091: pay_payroll_actions BACT,

5087: pay_run_result_values TARGET,
5088: pay_run_results RR,
5089: pay_payroll_actions PACT,
5090: pay_assignment_actions ASSACT,
5091: pay_payroll_actions BACT,
5092: pay_assignment_actions BAL_ASSACT
5093: where FEED.BALANCE_TYPE_ID = (
5094: select BALANCE_TYPE_ID
5095: from pay_balance_types

Line 5157: pay_payroll_actions PACT,

5153: from
5154: pay_balance_feeds_f FEED,
5155: pay_run_result_values TARGET,
5156: pay_run_results RR,
5157: pay_payroll_actions PACT,
5158: pay_assignment_actions ASSACT,
5159: pay_payroll_actions BACT,
5160: pay_assignment_actions BAL_ASSACT
5161: where FEED.BALANCE_TYPE_ID = (

Line 5159: pay_payroll_actions BACT,

5155: pay_run_result_values TARGET,
5156: pay_run_results RR,
5157: pay_payroll_actions PACT,
5158: pay_assignment_actions ASSACT,
5159: pay_payroll_actions BACT,
5160: pay_assignment_actions BAL_ASSACT
5161: where FEED.BALANCE_TYPE_ID = (
5162: select BALANCE_TYPE_ID
5163: from pay_balance_types