APPS.PAY_DYN_TRIGGERS dependencies on DUAL

Line 278: from sys.dual;

274: p_enabled_flag,
275: p_triggering_action,
276: p_short_name,
277: p_protected_flag
278: from sys.dual;
279: end;
280: --
281: end create_trigger_event;
282: --

Line 327: from sys.dual;

323: l_event_id,
324: p_variable_name,
325: p_data_type,
326: p_variable_size
327: from sys.dual;
328: --
329: end if;
330: --
331: end create_trg_declaration;

Line 377: from sys.dual;

373: l_event_id,
374: p_process_order,
375: p_plsql_code,
376: p_process_type
377: from sys.dual;
378: --
379: end if;
380: --
381: end create_trg_initialisation;

Line 481: from sys.dual;

477: l_bus_grp_id,
478: l_payroll_id,
479: p_module_name,
480: p_enabled_flag
481: from sys.dual;
482: --
483: end if;
484: --
485: end create_trg_components;

Line 608: from sys.dual;

604: p_parameter_type,
605: p_parameter_name,
606: p_value_name,
607: p_automatic
608: from sys.dual;
609: --
610: end if;
611: --
612: end create_trg_parameter;

Line 644: from sys.dual;

640: select
641: pay_functional_areas_s.nextval,
642: p_area_name,
643: p_description
644: from sys.dual;
645: --
646: end if;
647: --
648: end create_func_area;

Line 693: from sys.dual

689: select
690: pay_functional_triggers_s.nextval,
691: l_area_id,
692: l_event_id
693: from sys.dual
694: where not exists (select ''
695: from pay_functional_triggers
696: where area_id = l_area_id
697: and event_id = l_event_id);

Line 741: from sys.dual

737: p_column_name,
738: l_business_group_id,
739: p_legislation_code,
740: p_change_type
741: from sys.dual
742: where not exists (select ''
743: from pay_event_updates
744: where table_name = p_table_name
745: and column_name = p_column_name

Line 829: from sys.dual

825: l_area_id,
826: l_business_group_id,
827: p_legislation_code,
828: l_payroll_id
829: from sys.dual
830: where not exists( select 'X'
831: from pay_functional_usages
832: where area_id = l_area_id
833: and usage_id =to_number(p_usage_id)