[Home] [Help]
1587: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1588: from pay_run_result_values rrv,
1589: pay_run_results rr,
1590: pay_assignment_actions aa,
1591: pay_payroll_actions pa
1592: where rrv.input_value_id = p_input_value_id
1593: and rr.run_result_id = rrv.run_result_id
1594: and rr.status like 'P%'
1595: and aa.assignment_action_id = rr.assignment_action_id
1675: null
1676: from pay_run_result_values rrv,
1677: pay_run_results rr,
1678: pay_assignment_actions aa,
1679: pay_payroll_actions pa
1680: where rrv.input_value_id = bf.input_value_id
1681: and rr.run_result_id = rrv.run_result_id
1682: and rr.status like 'P%'
1683: and aa.assignment_action_id = rr.assignment_action_id
1698: USE_NL(rrv rr aa pa)
1699: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)
1700: INDEX(rr PAY_RUN_RESULTS_PK)
1701: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)
1702: INDEX(pa PAY_PAYROLL_ACTIONS_PK)
1703: */ 1
1704: from pay_run_result_values rrv,
1705: pay_run_results rr,
1706: pay_assignment_actions aa,
1703: */ 1
1704: from pay_run_result_values rrv,
1705: pay_run_results rr,
1706: pay_assignment_actions aa,
1707: pay_payroll_actions pa
1708: where rrv.input_value_id = p_input_value_id
1709: and rr.run_result_id = rrv.run_result_id
1710: and rr.status like 'P%'
1711: and aa.assignment_action_id = rr.assignment_action_id
1717: (
1718: p_validation_start_date date,
1719: p_validation_end_date date
1720: ) is
1721: select /*+ INDEX(pa pay_payroll_actions_n5)*/
1722: payroll_action_id
1723: from pay_payroll_actions pa
1724: where pa.effective_date between p_validation_start_date
1725: and p_validation_end_date
1719: p_validation_end_date date
1720: ) is
1721: select /*+ INDEX(pa pay_payroll_actions_n5)*/
1722: payroll_action_id
1723: from pay_payroll_actions pa
1724: where pa.effective_date between p_validation_start_date
1725: and p_validation_end_date
1726: and action_type in ('R', 'Q', 'B', 'I', 'V')
1727: order by payroll_action_id desc;