[Home] [Help]
2036: and ppa.action_status = 'C';
2037:
2038: cursor csr_run_result_id(lp_assignment_action_id number, lp_element_type_id number) is
2039: select prr.run_result_id
2040: from pay_run_results prr
2041: where
2042: prr.element_type_id=lp_element_type_id and
2043: prr.assignment_action_id=lp_assignment_action_id;
2044:
2449: pay_payroll_actions ppa,
2450: pay_assignment_actions paa,
2451: pay_element_types_f pet,
2452: pay_input_values_f piv,
2453: pay_run_results prr,
2454: pay_run_result_values prrv,
2455: per_time_periods ptp
2456: where
2457: pet.element_name='Standard Tax Deduction' and
2476: pay_assignment_actions paa,
2477: pay_payroll_actions ppa,
2478: pay_element_types_f pet,
2479: pay_input_values_f piv,
2480: pay_run_results prr,
2481: pay_run_result_values prrv,
2482: per_time_periods ptp
2483: where
2484: pet.element_name='Standard Tax Deduction' and
2660: pay_payroll_actions ppa,
2661: pay_assignment_actions paa,
2662: pay_element_types_f pet,
2663: pay_input_values_f piv,
2664: pay_run_results prr,
2665: pay_run_result_values prrv
2666: where
2667: pet.element_name='Standard Tax Deduction' and
2668: pet.element_type_id=piv.element_type_id and
2686: pay_assignment_actions paa,
2687: pay_payroll_actions ppa,
2688: pay_element_types_f pet,
2689: pay_input_values_f piv,
2690: pay_run_results prr,
2691: pay_run_result_values prrv
2692: where
2693: pet.element_name='Standard Tax Deduction' and
2694: pet.element_type_id=piv.element_type_id and
2755: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from
2756: pay_payrolls_f ppf
2757: ,pay_payroll_actions ppa
2758: ,pay_assignment_actions paa
2759: ,pay_run_results prr
2760: ,pay_element_types_f pet
2761: where ppa.payroll_action_id = paa.payroll_action_id
2762: and paa.assignment_id = p_assignment_id
2763: and paa.assignment_action_id = paa.assignment_action_id