[Home] [Help]
298: SELECT ptp.start_date,ptp.end_date
299: FROM per_time_periods ptp
300: WHERE (ptp.end_date > ( SELECT MAX(effective_date)
301: FROM pay_payroll_actions ppa
302: ,pay_assignment_actions paa
303: WHERE ppa.action_status='C'
304: AND ppa.action_type in ('R','Q')
305: AND ppa.business_group_id=cp_business_group_id
306: AND ppa.payroll_id=cp_payroll_id
2746: * FEED.scale),0) tot
2747: FROM pay_run_result_values TARGET
2748: , pay_balance_feeds_f FEED
2749: , pay_run_results RR
2750: , pay_assignment_actions ASSACT
2751: , pay_assignment_actions BAL_ASSACT
2752: , pay_payroll_actions PACT
2753: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
2754: AND FEED.balance_type_id = cp_balance_type_id
2747: FROM pay_run_result_values TARGET
2748: , pay_balance_feeds_f FEED
2749: , pay_run_results RR
2750: , pay_assignment_actions ASSACT
2751: , pay_assignment_actions BAL_ASSACT
2752: , pay_payroll_actions PACT
2753: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
2754: AND FEED.balance_type_id = cp_balance_type_id
2755: AND FEED.input_value_id = TARGET.input_value_id
2778: SELECT target.result_value tot
2779: FROM pay_run_result_values TARGET
2780: , pay_balance_feeds_f FEED
2781: , pay_run_results RR
2782: , pay_assignment_actions ASSACT
2783: , pay_assignment_actions BAL_ASSACT
2784: , pay_payroll_actions PACT
2785: WHERE bal_assact.assignment_action_id = cp_assignment_action_id
2786: AND FEED.input_value_id = TARGET.input_value_id
2779: FROM pay_run_result_values TARGET
2780: , pay_balance_feeds_f FEED
2781: , pay_run_results RR
2782: , pay_assignment_actions ASSACT
2783: , pay_assignment_actions BAL_ASSACT
2784: , pay_payroll_actions PACT
2785: WHERE bal_assact.assignment_action_id = cp_assignment_action_id
2786: AND FEED.input_value_id = TARGET.input_value_id
2787: AND TARGET.run_result_id = RR.run_result_id