DBA Data[Home] [Help]

APPS.IGW_PROP_APPROVALS_PVT dependencies on DUAL

Line 497: from dual;

493: p_rules_found := 'T';
494: if l_map_seq_number = 1 then
495: select igw_prop_approval_runs_s.nextval
496: into p_run_id
497: from dual;
498:
499: open next_run_number;
500: fetch next_run_number into l_run_number;
501: close next_run_number;

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

654: order by expression_sequence_number;
655:
656: begin
657:
658: l_select_stmt := 'select 1 from dual where ';
659:
660:
661: for c1 in business_rule_lines loop
662:

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

770: and special_review_code = p_rvalue_id;
771:
772:
773:
774: l_select_stmt varchar2(2000) := 'select 1 from dual where ';
775: l_answer varchar2(1);
776: l_total_cost number(15,2);
777: l_total_direct_cost number(15,2);
778: l_total_indirect_cost number(15,2);