eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_TX_01032012 dependencies on PAY_PAYROLL_ACTIONS

Line 362: , pay_payroll_actions ppa

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

Line 366: , pay_payroll_actions ppa_all

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
369: , pay_balance_feeds_f feed
370: , pay_run_result_values process

Line 7220: , pay_payroll_actions ppa

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

Line 7224: , pay_payroll_actions ppa_all

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
7227: , pay_balance_feeds_f feed
7228: , pay_run_result_values process

Line 8292: pay_payroll_actions PACT,

8288: from
8289: pay_balance_feeds_f FEED,
8290: pay_run_result_values TARGET,
8291: pay_run_results RR,
8292: pay_payroll_actions PACT,
8293: pay_assignment_actions ASSACT,
8294: pay_payroll_actions BACT,
8295: pay_assignment_actions BAL_ASSACT
8296: where FEED.BALANCE_TYPE_ID = (

Line 8294: pay_payroll_actions BACT,

8290: pay_run_result_values TARGET,
8291: pay_run_results RR,
8292: pay_payroll_actions PACT,
8293: pay_assignment_actions ASSACT,
8294: pay_payroll_actions BACT,
8295: pay_assignment_actions BAL_ASSACT
8296: where FEED.BALANCE_TYPE_ID = (
8297: select BALANCE_TYPE_ID
8298: from pay_balance_types

Line 8360: pay_payroll_actions PACT,

8356: from
8357: pay_balance_feeds_f FEED,
8358: pay_run_result_values TARGET,
8359: pay_run_results RR,
8360: pay_payroll_actions PACT,
8361: pay_assignment_actions ASSACT,
8362: pay_payroll_actions BACT,
8363: pay_assignment_actions BAL_ASSACT
8364: where FEED.BALANCE_TYPE_ID = (

Line 8362: pay_payroll_actions BACT,

8358: pay_run_result_values TARGET,
8359: pay_run_results RR,
8360: pay_payroll_actions PACT,
8361: pay_assignment_actions ASSACT,
8362: pay_payroll_actions BACT,
8363: pay_assignment_actions BAL_ASSACT
8364: where FEED.BALANCE_TYPE_ID = (
8365: select BALANCE_TYPE_ID
8366: from pay_balance_types