APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1634: pay_payroll_actions PAYROLL

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
1637: and assign.payroll_action_id = payroll.payroll_action_id
1638: and value.input_value_id = p_input_value_id

Line 1646: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)

1642: cursor csr_run_results is
1643: select 1
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

Line 1649: pay_payroll_actions PAYROLL,

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
1653: and assign.payroll_action_id = payroll.payroll_action_id