[Home] [Help]
2018: and ppa.action_status = 'C';
2019:
2020: cursor csr_run_result_id(lp_assignment_action_id number, lp_element_type_id number) is
2021: select prr.run_result_id
2022: from pay_run_results prr
2023: where
2024: prr.element_type_id=lp_element_type_id and
2025: prr.assignment_action_id=lp_assignment_action_id;
2026:
2431: pay_payroll_actions ppa,
2432: pay_assignment_actions paa,
2433: pay_element_types_f pet,
2434: pay_input_values_f piv,
2435: pay_run_results prr,
2436: pay_run_result_values prrv,
2437: per_time_periods ptp
2438: where
2439: pet.element_name='Standard Tax Deduction' and
2457: pay_assignment_actions paa,
2458: pay_payroll_actions ppa,
2459: pay_element_types_f pet,
2460: pay_input_values_f piv,
2461: pay_run_results prr,
2462: pay_run_result_values prrv,
2463: per_time_periods ptp
2464: where
2465: pet.element_name='Standard Tax Deduction' and
2637: pay_payroll_actions ppa,
2638: pay_assignment_actions paa,
2639: pay_element_types_f pet,
2640: pay_input_values_f piv,
2641: pay_run_results prr,
2642: pay_run_result_values prrv
2643: where
2644: pet.element_name='Standard Tax Deduction' and
2645: pet.element_type_id=piv.element_type_id and
2662: pay_assignment_actions paa,
2663: pay_payroll_actions ppa,
2664: pay_element_types_f pet,
2665: pay_input_values_f piv,
2666: pay_run_results prr,
2667: pay_run_result_values prrv
2668: where
2669: pet.element_name='Standard Tax Deduction' and
2670: pet.element_type_id=piv.element_type_id and
2725: select 1 from dual
2726: where exists
2727: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from pay_payroll_actions ppa
2728: ,pay_assignment_actions paa
2729: ,pay_run_results prr
2730: ,pay_element_types_f pet
2731: where ppa.payroll_action_id = paa.payroll_action_id
2732: and paa.assignment_id = p_assignment_id
2733: and paa.assignment_action_id = paa.assignment_action_id