APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_CONVENTIONS

Line 425: FROM fa_conventions conv

421:
422: -- Get prorate date
423: SELECT to_number(to_char(conv.prorate_date,'J'))
424: INTO dpr_in.prorate_jdate
425: FROM fa_conventions conv
426: WHERE conv.prorate_convention_code = h_prorate_conv
427: AND X_dpis between conv.start_date and conv.end_date;
428:
429: --fa_rx_conc_mesg_pkg.log('step 1.3');

Line 685: from fa_conventions

681: end if;
682:
683: if (X_prorate_conv is not null) then
684: select prorate_date into fin_info.prorate_date
685: from fa_conventions
686: where prorate_convention_code = X_prorate_conv
687: and fin_info.date_placed_in_svc between start_date and end_date;
688:
689: dpr_in.prorate_jdate := to_number(to_char(fin_info.prorate_date,'J'));