[Home] [Help]
83: begin
84: --
85: select 'N'
86: into v_validation_check
87: from sys.dual
88: where exists
89: (select 1
90: from pay_element_links_f el,
91: pay_element_entries_f ee
111: -- This will ensure also that only one PAY_VALUE can be used.
112: begin
113: select 'N'
114: into v_validation_check
115: from sys.dual
116: where exists
117: (select 1
118: from pay_input_values_f_tl ipv_tl,
119: pay_input_values_f ipv
234: v_validation_check := 'Y';
235: --
236: select 'N'
237: into v_validation_check
238: from sys.dual
239: where not exists(select 1
240: from hr_lookups
241: where lookup_type = p_lookup_type
242: and lookup_code = p_default_value);
259: begin
260: --
261: select 'N'
262: into v_validation_check
263: from sys.dual
264: where exists
265: (select 1
266: from pay_run_results rr
267: where rr.element_type_id = p_element_type_id);
304: begin
305: --
306: select 'Y'
307: into null_entries_found
308: from sys.dual
309: where not exists(
310: select 1
311: from pay_element_entries_f ee,
312: pay_element_entry_values_f eev
325: begin
326: --
327: select 'Y'
328: into null_entries_found
329: from sys.dual
330: where exists(
331: select 1
332: from pay_element_entries_f ee,
333: pay_element_entry_values_f eev
383: begin
384: --
385: select 'Y'
386: into l_min_value_missing
387: from sys.dual
388: where exists
389: (select 1
390: from pay_input_values_f iv
391: where p_input_value_id = iv.input_value_id
407: begin
408: --
409: select 'Y'
410: into l_max_value_missing
411: from sys.dual
412: where exists
413: (select 1
414: from pay_input_values_f iv
415: where p_input_value_id = iv.input_value_id
436: begin
437: --
438: select 'Y'
439: into l_default_value_missing
440: from sys.dual
441: where exists
442: (select 1
443: from pay_input_values_f iv
444: where p_input_value_id = iv.input_value_id
612: l_pay_value_name := hr_input_values.get_pay_value_name(null);
613: --
614: select 'Y'
615: into v_links_exist_flag
616: from sys.dual
617: where exists
618: (select 1
619: from pay_element_links_f el,
620: pay_input_values_f_tl ip_tl,
647: -- Test to see if there are any element entry values during validation period
648: --
649: select 'Y'
650: into v_entries_exist_flag
651: from sys.dual
652: where exists
653: (select 1
654: from pay_element_entry_values_f
655: where input_value_id = p_input_value_id
670: -- the validation period.
671: --
672: select 'Y'
673: into v_results_exist_flag
674: from sys.dual
675: where exists
676: (select 1
677: from pay_formula_result_rules_f
678: where input_value_id = p_input_value_id
694: -- payroll_actions table
695: --
696: select 'Y'
697: into v_run_results_exist_flag
698: from sys.dual
699: where exists
700: (select /*+ INDEX(rr PAY_RUN_RESULTS_PK) */ 1
701: from pay_run_result_values rrv,
702: pay_run_results rr,
723: -- This input value.
724: --
725: select 'Y'
726: into v_results_exist_flag
727: from sys.dual
728: where exists
729: (select 1
730: from per_absence_attendance_types
731: where input_value_id = p_input_value_id
746: -- This input value.
747: --
748: select 'Y'
749: into v_results_exist_flag
750: from sys.dual
751: where exists
752: (select 1
753: from pay_backpay_rules
754: where input_value_id = p_input_value_id);
793: begin
794: --
795: select 'Y'
796: into l_validation_check
797: from sys.dual
798: where p_val_end_date =
799: (select max(iv1.effective_end_date)
800: from pay_input_values iv1
801: where iv1.input_value_id = p_input_value_id)
939: begin
940:
941: select 'Y'
942: into l_validation_check
943: from sys.dual
944: where exists
945: (select 1
946: from pay_input_values_f iv
947: where iv.input_value_id = p_input_value_id
967: begin
968: --
969: select 'Y'
970: into v_entries_exist_flag
971: from sys.dual
972: where exists
973: (select 1
974: from pay_element_links_f el,
975: pay_element_entries_f ee
1027: begin
1028: --
1029: select 'Y'
1030: into l_link_inputs_exist
1031: from sys.dual
1032: where exists
1033: (select 1
1034: from pay_link_input_values_f liv
1035: where liv.input_value_id = p_input_value_id);
1101: --
1102: -- Get sequence number for link_input_value
1103: select pay_link_input_values_s.nextval
1104: into v_link_input_value_id
1105: from sys.dual;
1106: --
1107: -- Copy the date effective rows from the input value to the link input
1108: -- value where they overlap
1109: insert into pay_link_input_values_f