APPS.FA_GAINLOSS_RET_PKG dependencies on DUAL

Line 573: FROM dual;

569:
570: begin
571: SELECT h_deprn_start_date
572: INTO h_ret_prorate_date
573: FROM dual;
574: exception
575: when no_data_found then
576: null;
577: end;

Line 582: FROM dual

578: else
579: begin
580: SELECT h_deprn_start_date
581: INTO h_ret_prorate_date
582: FROM dual
583: where trunc(h_ret_prorate_date) < trunc(h_deprn_start_date);
584: exception
585: when no_data_found then
586: null;

Line 599: FROM dual

595:
596: begin
597: SELECT h_prorate_date
598: INTO h_ret_prorate_date
599: FROM dual
600: WHERE trunc(h_ret_prorate_date) < trunc(h_prorate_date);
601: exception
602: when no_data_found then
603: null;