APPS.PY_ZA_TX_01032013 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 355: FROM pay_assignment_actions paa

351: cursor csr_get_tax_dir_info(p_assignment_id number)
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

Line 359: , pay_assignment_actions paa_all

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

Line 4304: FROM pay_assignment_actions paa

4300: xpt_FxdPrc EXCEPTION;
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

Line 4308: , pay_assignment_actions paa_all

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

Line 5090: pay_assignment_actions ASSACT,

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 = (
5094: select BALANCE_TYPE_ID

Line 5092: pay_assignment_actions BAL_ASSACT

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
5096: where balance_name= 'Tax on Lump Sums'

Line 5158: pay_assignment_actions ASSACT,

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 = (
5162: select BALANCE_TYPE_ID

Line 5160: pay_assignment_actions BAL_ASSACT

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
5164: where balance_name= 'Tax on Retirement Fund Lump Sums'