DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1639: pay_payroll_actions PAYROLL

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

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

1647: cursor csr_run_results is
1648: select 1
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

Line 1654: pay_payroll_actions PAYROLL,

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