[Home] [Help]
321: p_deduction_element_type_id number default null) is
322: --
323: cursor csr_new_id is
324: select pay_element_types_s.nextval
325: from sys.dual;
326: --
327: cursor csr_element_rowid is
328: --
329: -- Returns the system-generated columns for return to the
1302:
1303: -- Bug 6411503. Checking for time_definition_type
1304: select DECODE(element_record.time_definition_type, 'N', NULL, element_record.TIME_DEFINITION_TYPE)
1305: into l_time_definition_type
1306: from dual;
1307:
1308: if
1309: --
1310: ((element_record.additional_entry_allowed_flag = p_additional_entry_allowed)
1628: where iv.element_type_id = p_element_type_id;
1629:
1630: cursor csr_run_result_values (p_input_value_id NUMBER) is
1631: select 1
1632: from dual
1633: where exists
1634: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)
1635: USE_NL(RESULT ASSIGN PAYROLL) */ 1
1636: from pay_run_result_values VALUE,
1645: and p_validation_end_date);
1646:
1647: cursor csr_run_results is
1648: select 1
1649: from dual
1650: where exists
1651: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1652: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1653: from pay_run_results RUN,
1660: and p_validation_end_date);
1661:
1662: cursor csr_default_run_result_values (p_input_value_id NUMBER) is
1663: select 1
1664: from dual
1665: where exists
1666: (select 1
1667: from pay_run_result_values VALUE
1668: where value.input_value_id = p_input_value_id);
1909: begin
1910: --
1911: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',1);
1912: --
1913: -- Perform individual checks and place results directly in the OUT parameters
1914: --
1915: p_run_results := run_results_exist ( p_element_type_id,
1916: p_validation_start_date,
1917: p_validation_end_date);