APPS.PAY_TEMPLATE_IVS dependencies on DUAL

Line 677: from sys.dual

673: begin
674: --
675: select 'N'
676: into v_validation_check
677: from sys.dual
678: where exists
679: (select 1
680: from pay_element_links_f el,
681: pay_element_entries_f ee

Line 709: from sys.dual

705: -- This will ensure also that only one PAY_VALUE can be used.
706: begin
707: select 'N'
708: into v_validation_check
709: from sys.dual
710: where exists
711: (select 1
712: from pay_input_values_f
713: where element_type_id = p_element_type_id

Line 838: from sys.dual

834: v_validation_check := 'Y';
835: --
836: select 'N'
837: into v_validation_check
838: from sys.dual
839: where not exists(select 1
840: from hr_lookups
841: where lookup_type = p_lookup_type
842: and lookup_code = p_default_value);

Line 867: from sys.dual

863: begin
864: --
865: select 'N'
866: into v_validation_check
867: from sys.dual
868: where exists
869: (select 1
870: from pay_run_results rr
871: where rr.element_type_id = p_element_type_id);