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 843: FROM dual

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