[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
1297:
1298: -- Bug 6411503. Checking for time_definition_type
1299: select DECODE(element_record.time_definition_type, 'N', NULL, element_record.TIME_DEFINITION_TYPE)
1300: into l_time_definition_type
1301: from dual;
1302:
1303: if
1304: --
1305: ((element_record.additional_entry_allowed_flag = p_additional_entry_allowed)
1623: where iv.element_type_id = p_element_type_id;
1624:
1625: cursor csr_run_result_values (p_input_value_id NUMBER) is
1626: select 1
1627: from dual
1628: where exists
1629: (select /*+ ORDERED INDEX(RESULT PAY_RUN_RESULTS_PK)
1630: USE_NL(RESULT ASSIGN PAYROLL) */ 1
1631: from pay_run_result_values VALUE,
1640: and p_validation_end_date);
1641:
1642: cursor csr_run_results is
1643: select 1
1644: from dual
1645: where exists
1646: (select /*+ INDEX(PAYROLL PAY_PAYROLL_ACTIONS_PK)
1647: INDEX(ASSIGN PAY_ASSIGNMENT_ACTIONS_PK) */ 1
1648: from pay_run_results RUN,
1876: begin
1877: --
1878: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.CHECK_RELATIONSHIPS',1);
1879: --
1880: -- Perform individual checks and place results directly in the OUT parameters
1881: --
1882: p_run_results := run_results_exist ( p_element_type_id,
1883: p_validation_start_date,
1884: p_validation_end_date);