APPS.IGW_PROPOSAL_APPROVAL dependencies on DUAL

Line 504: from dual;

500: p_rules_found := 'T';
501: if l_map_seq_number = 1 then
502: select igw_prop_approval_runs_s.nextval
503: into p_run_id
504: from dual;
505:
506: open next_run_number;
507: fetch next_run_number into l_run_number;
508: close next_run_number;

Line 670: l_select_stmt := 'select 1 from dual where ';

666: order by expression_sequence_number;
667:
668: begin
669:
670: l_select_stmt := 'select 1 from dual where ';
671:
672:
673: for c1 in business_rule_lines loop
674:

Line 786: l_select_stmt varchar2(2000) := 'select 1 from dual where ';

782: and special_review_code = p_rvalue_id;
783:
784:
785:
786: l_select_stmt varchar2(2000) := 'select 1 from dual where ';
787: l_answer varchar2(1);
788: l_total_cost number(15,2);
789: l_total_direct_cost number(15,2);
790: l_total_indirect_cost number(15,2);