APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_RUN_RESULTS

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

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

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

1625: cursor csr_run_result_values (p_input_value_id NUMBER) is
1626: select 1
1627: from dual
1628: where exists
1629: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)
1630: USE_NL(RESULT ASSIGN PAYROLL) */ 1
1631: from pay_run_result_values VALUE,
1632: pay_run_results RESULT,
1633: pay_assignment_actions ASSIGN,

Line 1632: pay_run_results RESULT,

1628: where exists
1629: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)
1630: USE_NL(RESULT ASSIGN PAYROLL) */ 1
1631: from pay_run_result_values VALUE,
1632: pay_run_results RESULT,
1633: pay_assignment_actions ASSIGN,
1634: pay_payroll_actions PAYROLL
1635: where value.run_result_id = result.run_result_id
1636: and assign.assignment_action_id = result.assignment_action_id

Line 1648: from pay_run_results RUN,

1644: from dual
1645: where exists
1646: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1647: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1648: from pay_run_results RUN,
1649: pay_payroll_actions PAYROLL,
1650: pay_assignment_actions ASSIGN
1651: where run.element_type_id = p_element_type_id
1652: and assign.assignment_action_id = run.assignment_action_id