APPS.FA_GAINLOSS_MIS_PKG dependencies on DUAL

Line 817: FROM dual;

813:
814: begin
815: SELECT h_deprn_start_date
816: INTO h_ret_prorate_date
817: FROM dual;
818: exception
819: when no_data_found then
820: null;
821: end;

Line 826: FROM dual

822: else
823: begin
824: SELECT h_deprn_start_date
825: INTO h_ret_prorate_date
826: FROM dual
827: where trunc(h_ret_prorate_date) < trunc(h_deprn_start_date);
828: exception
829: when no_data_found then
830: null;

Line 845: FROM dual

841:
842: begin
843: SELECT h_prorate_date
844: INTO h_ret_prorate_date
845: FROM dual
846: WHERE trunc(h_ret_prorate_date) < trunc(h_prorate_date);
847: exception
848: when no_data_found then
849: null;