APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_RUN_RESULTS

Line 1602: --* the element_type_id index on pay_run_results. The function now *

1598: --************************************************************************
1599: --* Returns TRUE if run results exist for the parameter element type, in *
1600: --* payroll actions during the validation period *
1601: --* The driving cursors have been rewritten to allow for the removal of *
1602: --* the element_type_id index on pay_run_results. The function now *
1603: --* relies on their being run result values present for any input value *
1604: --* if the element would have run results. The only current exception *
1605: --* to this would be for elements with no input values. This is handled *
1606: --* in a different, less performant cursor. *

Line 1634: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)

1630: cursor csr_run_result_values (p_input_value_id NUMBER) is
1631: select 1
1632: from dual
1633: where exists
1634: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)
1635: USE_NL(RESULT ASSIGN PAYROLL) */ 1
1636: from pay_run_result_values VALUE,
1637: pay_run_results RESULT,
1638: pay_assignment_actions ASSIGN,

Line 1637: pay_run_results RESULT,

1633: where exists
1634: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)
1635: USE_NL(RESULT ASSIGN PAYROLL) */ 1
1636: from pay_run_result_values VALUE,
1637: pay_run_results RESULT,
1638: pay_assignment_actions ASSIGN,
1639: pay_payroll_actions PAYROLL
1640: where value.run_result_id = result.run_result_id
1641: and assign.assignment_action_id = result.assignment_action_id

Line 1653: from pay_run_results RUN,

1649: from dual
1650: where exists
1651: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1652: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1653: from pay_run_results RUN,
1654: pay_payroll_actions PAYROLL,
1655: pay_assignment_actions ASSIGN
1656: where run.element_type_id = p_element_type_id
1657: and assign.assignment_action_id = run.assignment_action_id