DBA Data[Home] [Help]

APPS.JGRX_FAREG dependencies on FA_DEPRN_PERIODS

Line 758: FROM fa_deprn_periods

754: INTO PARM.p_begin_period_from_date,
755: PARM.p_begin_period_to_date,
756: PARM.p_begin_period_counter,
757: X_fiscal_year
758: FROM fa_deprn_periods
759: WHERE book_type_code = PARM.p_book_type_code
760: AND period_counter > (SELECT MIN(DP2.period_counter)
761: FROM fa_deprn_periods DP2
762: WHERE DP2.book_type_code = PARM.p_book_type_code)

Line 761: FROM fa_deprn_periods DP2

757: X_fiscal_year
758: FROM fa_deprn_periods
759: WHERE book_type_code = PARM.p_book_type_code
760: AND period_counter > (SELECT MIN(DP2.period_counter)
761: FROM fa_deprn_periods DP2
762: WHERE DP2.book_type_code = PARM.p_book_type_code)
763: AND period_name = PARM.p_period_from;
764: END IF;
765:

Line 775: FROM fa_deprn_periods

771: period_counter
772: INTO PARM.p_end_period_from_date,
773: PARM.p_end_period_to_date,
774: PARM.p_end_period_counter
775: FROM fa_deprn_periods
776: WHERE book_type_code = PARM.p_book_type_code
777: AND period_counter > (SELECT MIN(DP2.period_counter)
778: FROM fa_deprn_periods DP2
779: WHERE DP2.book_type_code = PARM.p_book_type_code)

Line 778: FROM fa_deprn_periods DP2

774: PARM.p_end_period_counter
775: FROM fa_deprn_periods
776: WHERE book_type_code = PARM.p_book_type_code
777: AND period_counter > (SELECT MIN(DP2.period_counter)
778: FROM fa_deprn_periods DP2
779: WHERE DP2.book_type_code = PARM.p_book_type_code)
780: AND period_name = PARM.p_period_to;
781: END IF;
782: