DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1668: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1

1664: select 1
1665: from dual
1666: where exists
1667: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1668: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1669: from pay_run_results RUN,
1670: pay_payroll_actions PAYROLL,
1671: pay_assignment_actions ASSIGN
1672: where run.element_type_id = p_element_type_id

Line 1671: pay_assignment_actions ASSIGN

1667: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1668: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1669: from pay_run_results RUN,
1670: pay_payroll_actions PAYROLL,
1671: pay_assignment_actions ASSIGN
1672: where run.element_type_id = p_element_type_id
1673: and assign.assignment_action_id = run.assignment_action_id
1674: and assign.payroll_action_id = payroll.payroll_action_id
1675: and payroll.effective_date between p_start_date