APPS.FA_C_INSURE dependencies on FA_DEPRN_PERIODS

Line 750: fa_deprn_periods fdp

746: floor(months_between(fdp.calendar_period_close_date,
747: bks.date_placed_in_service))
748: asset_remaining_life
749: FROM fa_books bks,
750: fa_deprn_periods fdp
751: WHERE bks.book_type_code = P_asset_book
752: AND fdp.book_type_code = P_asset_book
753: AND bks.book_type_code = fdp.book_type_code
754: AND bks.asset_id = pol_asset_id

Line 771: fa_deprn_periods fdp

767: SELECT (bks.life_in_months -
768: floor(months_between(fdp.calendar_period_close_date,
769: bks.date_placed_in_service)+1))
770: FROM fa_books bks,
771: fa_deprn_periods fdp
772: WHERE bks.book_type_code = P_asset_book
773: AND fdp.book_type_code = P_asset_book
774: AND bks.asset_id = pol_asset_id
775: AND pol_indexation_date between

Line 1042: FROM fa_Deprn_periods fdp1,

1038: fdp2.period_counter,
1039: fdp2.period_close_date,
1040: fdp1.period_open_date,
1041: fdp1.calendar_period_open_date - 1
1042: FROM fa_Deprn_periods fdp1,
1043: fa_Deprn_periods fdp2
1044: WHERE fdp1.period_counter =
1045: (SELECT MIN(x.period_counter)
1046: FROM fa_Deprn_periods x

Line 1043: fa_Deprn_periods fdp2

1039: fdp2.period_close_date,
1040: fdp1.period_open_date,
1041: fdp1.calendar_period_open_date - 1
1042: FROM fa_Deprn_periods fdp1,
1043: fa_Deprn_periods fdp2
1044: WHERE fdp1.period_counter =
1045: (SELECT MIN(x.period_counter)
1046: FROM fa_Deprn_periods x
1047: WHERE x.fiscal_year = p_year

Line 1046: FROM fa_Deprn_periods x

1042: FROM fa_Deprn_periods fdp1,
1043: fa_Deprn_periods fdp2
1044: WHERE fdp1.period_counter =
1045: (SELECT MIN(x.period_counter)
1046: FROM fa_Deprn_periods x
1047: WHERE x.fiscal_year = p_year
1048: AND x.book_type_code = p_asset_book
1049: )
1050: AND fdp2.period_counter =

Line 1052: FROM fa_Deprn_periods x

1048: AND x.book_type_code = p_asset_book
1049: )
1050: AND fdp2.period_counter =
1051: (SELECT MAX(x.period_counter)
1052: FROM fa_Deprn_periods x
1053: WHERE x.fiscal_year = p_year
1054: AND x.book_type_code = p_asset_book
1055: )
1056: AND fdp2.book_type_code = fdp1.book_type_code

Line 1067: FROM fa_deprn_periods fdp1

1063: P_Year VARCHAR2
1064: ) IS
1065: SELECT fdp1.CALENDAR_PERIOD_CLOSE_DATE,
1066: fdp1.period_counter
1067: FROM fa_deprn_periods fdp1
1068: WHERE fdp1.book_type_code = p_asset_book
1069: AND fdp1.fiscal_year = p_year
1070: AND fdp1.period_counter =
1071: (SELECT MAX(fdp.period_counter)

Line 1072: FROM fa_deprn_periods fdp

1068: WHERE fdp1.book_type_code = p_asset_book
1069: AND fdp1.fiscal_year = p_year
1070: AND fdp1.period_counter =
1071: (SELECT MAX(fdp.period_counter)
1072: FROM fa_deprn_periods fdp
1073: WHERE fdp.book_type_code = p_asset_book
1074: AND fdp.fiscal_year = p_year
1075: AND fdp.period_close_date IS NOT NULL
1076: );