DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 1670: pay_payroll_actions PAYROLL,

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