DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1799: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1

1795: select 1
1796: from dual
1797: where exists
1798: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1799: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1800: from pay_run_results RUN,
1801: pay_payroll_actions PAYROLL,
1802: pay_assignment_actions ASSIGN
1803: where run.element_type_id = p_element_type_id

Line 1802: pay_assignment_actions ASSIGN

1798: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1799: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1800: from pay_run_results RUN,
1801: pay_payroll_actions PAYROLL,
1802: pay_assignment_actions ASSIGN
1803: where run.element_type_id = p_element_type_id
1804: and assign.assignment_action_id = run.assignment_action_id
1805: and assign.payroll_action_id = payroll.payroll_action_id
1806: and payroll.effective_date between p_start_date