DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_RUN_RESULTS

Line 1643: -- element entries or pay run results for this element type

1639: -- Description:
1640: -- This procedure will do the following validations
1641: -- 1) Only 15 input values can be created for each element
1642: -- 2) Insert should not be allowed if there exists
1643: -- element entries or pay run results for this element type
1644: -- 3) Any of the following combinations can be entered at a time,
1645: -- 1) FORMULA_ID and DEFAULT_VALUE
1646: -- 2) LOOKUP_TYPE and DEFAULT_VALUE
1647: -- 3) DEFAULT_VALUE, MIN_VALUE and MAX_VALUE

Line 1669: from pay_run_results RUN,

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