DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_PAYROLL_ACTIONS

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

1794: cursor csr_run_results is
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

Line 1801: pay_payroll_actions PAYROLL,

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
1804: and assign.assignment_action_id = run.assignment_action_id
1805: and assign.payroll_action_id = payroll.payroll_action_id