APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_CONVENTIONS

Line 401: FROM fa_conventions conv

397:
398: -- Get prorate date
399: SELECT to_number(to_char(conv.prorate_date,'J'))
400: INTO dpr_in.prorate_jdate
401: FROM fa_conventions conv
402: WHERE conv.prorate_convention_code = h_prorate_conv
403: AND X_dpis between conv.start_date and conv.end_date;
404:
405: --fa_rx_conc_mesg_pkg.log('step 1.3');

Line 656: from fa_conventions

652: end if;
653:
654: if (X_prorate_conv is not null) then
655: select prorate_date into fin_info.prorate_date
656: from fa_conventions
657: where prorate_convention_code = X_prorate_conv
658: and fin_info.date_placed_in_svc between start_date and end_date;
659:
660: dpr_in.prorate_jdate := to_number(to_char(fin_info.prorate_date,'J'));