APPS.JG_RX_FAREG dependencies on FA_DEPRN_PERIODS

Line 902: FROM fa_deprn_periods

898: INTO PARM.p_begin_period_from_date,
899: PARM.p_begin_period_to_date,
900: PARM.p_begin_period_counter,
901: X_fiscal_year
902: FROM fa_deprn_periods
903: WHERE book_type_code = PARM.p_book_type_code
904: AND period_counter > (SELECT MIN(DP2.period_counter)
905: FROM fa_deprn_periods DP2
906: WHERE DP2.book_type_code = PARM.p_book_type_code)

Line 905: FROM fa_deprn_periods DP2

901: X_fiscal_year
902: FROM fa_deprn_periods
903: WHERE book_type_code = PARM.p_book_type_code
904: AND period_counter > (SELECT MIN(DP2.period_counter)
905: FROM fa_deprn_periods DP2
906: WHERE DP2.book_type_code = PARM.p_book_type_code)
907: AND period_name = PARM.p_period_from;
908: END IF;
909:

Line 919: FROM fa_deprn_periods

915: period_counter
916: INTO PARM.p_end_period_from_date,
917: PARM.p_end_period_to_date,
918: PARM.p_end_period_counter
919: FROM fa_deprn_periods
920: WHERE book_type_code = PARM.p_book_type_code
921: AND period_counter > (SELECT MIN(DP2.period_counter)
922: FROM fa_deprn_periods DP2
923: WHERE DP2.book_type_code = PARM.p_book_type_code)

Line 922: FROM fa_deprn_periods DP2

918: PARM.p_end_period_counter
919: FROM fa_deprn_periods
920: WHERE book_type_code = PARM.p_book_type_code
921: AND period_counter > (SELECT MIN(DP2.period_counter)
922: FROM fa_deprn_periods DP2
923: WHERE DP2.book_type_code = PARM.p_book_type_code)
924: AND period_name = PARM.p_period_to;
925: END IF;
926:

Line 1155: FROM fa_deprn_periods

1151: -- the current year of the asset's life rather than the entire life
1152: -- of the asset (X_life_of_asset) when joining to fa_rates.
1153: SELECT fiscal_year
1154: INTO X_current_fiscal_year
1155: FROM fa_deprn_periods
1156: WHERE book_type_code = PARM.p_book_type_code
1157: AND period_name = PARM.p_period_from;
1158:
1159: SELECT fy.fiscal_year