DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_RUN_RESULTS

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

1770: -- Description:
1771: -- This procedure will do the following validations
1772: -- 1) Only 15 input values can be created for each element
1773: -- 2) Insert should not be allowed if there exists
1774: -- element entries or pay run results for this element type
1775: -- 3) Any of the following combinations can be entered at a time,
1776: -- 1) FORMULA_ID and DEFAULT_VALUE
1777: -- 2) LOOKUP_TYPE and DEFAULT_VALUE
1778: -- 3) DEFAULT_VALUE, MIN_VALUE and MAX_VALUE

Line 1800: from pay_run_results RUN,

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