APPS.HR_ELEMENTS dependencies on DUAL

Line 28: from sys.dual

24: begin
25: --
26: select 'N'
27: into v_validation_check
28: from sys.dual
29: where exists (select 1
30: from pay_element_types_f
31: where upper(p_element_name) = upper(element_name)
32: and (p_element_type_id <> element_type_id

Line 77: -- from sys.dual

73: -- begin
74: --
75: -- select 'N'
76: -- into v_validation_check
77: -- from sys.dual
78: -- where exists (select 1
79: -- from pay_element_types_f
80: -- where upper(p_reporting_name) = upper(reporting_name)
81: -- and (p_element_type_id <> element_type_id

Line 309: from sys.dual

305: begin
306: --
307: select 'N'
308: into v_validation_check
309: from sys.dual
310: where exists (select 1
311: from pay_element_links_f el
312: where el.element_type_id = p_element_type_id
313: and el.effective_start_date <= p_val_end_date

Line 345: from sys.dual

341: begin
342: --
343: select 'Y'
344: into l_no_process_update
345: from sys.dual
346: where p_val_start_date =
347: (select min(effective_start_date)
348: from pay_element_types_f
349: where element_type_id = p_element_type_id)

Line 396: from sys.dual

392: begin
393: --
394: select 'Y'
395: into l_no_process_update
396: from sys.dual
397: where p_val_start_date =
398: (select min(effective_start_date)
399: from pay_element_types_f
400: where element_type_id = p_element_type_id)

Line 446: from sys.dual

442: begin
443: --
444: select 'N'
445: into v_validation_check
446: from sys.dual
447: where exists
448: (select 1
449: from pay_formula_result_rules_f frr,
450: pay_input_values_f iv

Line 471: from sys.dual

467: begin
468: --
469: select 'N'
470: into v_validation_check
471: from sys.dual
472: where exists
473: (select 1
474: from pay_run_results rr,
475: pay_assignment_actions aa,

Line 522: from sys.dual

518: begin
519: --
520: select 'N'
521: into v_validation_check
522: from sys.dual
523: where exists (select 1
524: from pay_status_processing_rules_f spr,
525: pay_formula_result_rules_f fr,
526: pay_input_values_f iv,

Line 556: from sys.dual

552: begin
553: --
554: select 'N'
555: into v_validation_check
556: from sys.dual
557: where exists(select 1
558: from pay_status_processing_rules_f spr,
559: pay_formula_result_rules_f fr,
560: pay_input_values_f iv,

Line 637: from sys.dual

633: begin
634: --
635: select 'N'
636: into v_validation_check
637: from sys.dual
638: where exists (select 1
639: from pay_element_links_f el
640: where el.element_type_id = p_element_type_id
641: and el.effective_end_date >= p_val_start_date

Line 684: from sys.dual

680: begin
681: --
682: select 'Y'
683: into v_run_results_exist
684: from sys.dual
685: where exists
686: (select 1
687: from pay_run_results rr,
688: pay_assignment_actions aa,

Line 716: from sys.dual

712: begin
713: --
714: select 'Y'
715: into v_element_rules_exist
716: from sys.dual
717: where exists
718: (select 1
719: from pay_element_type_rules
720: where element_type_id = p_element_type_id);

Line 787: from sys.dual;

783: --
784: -- Obtain sequence number for input value
785: select pay_input_values_s.nextval
786: into v_input_value_id
787: from sys.dual;
788: --
789: --
790: if g_debug then
791: hr_utility.set_location('hr_elements.ins_input_value', 2);

Line 1017: from dual;

1013: end if;
1014: --
1015: select pay_sub_classification_rules_s.nextval
1016: into l_sub_classification_rule_id
1017: from dual;
1018: --
1019: -- Insert sub_classification rule.
1020: --
1021: insert into pay_sub_classification_rules_f