APPS.FA_C_INSURE dependencies on FA_DEPRN_PERIODS

Line 752: fa_deprn_periods fdp

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

Line 773: fa_deprn_periods fdp

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

Line 1049: FROM fa_Deprn_periods fdp1,

1045: fdp2.period_counter,
1046: fdp2.period_close_date,
1047: fdp1.period_open_date,
1048: fdp1.calendar_period_open_date - 1
1049: FROM fa_Deprn_periods fdp1,
1050: fa_Deprn_periods fdp2
1051: WHERE fdp1.period_counter =
1052: (SELECT MIN(x.period_counter)
1053: FROM fa_Deprn_periods x

Line 1050: fa_Deprn_periods fdp2

1046: fdp2.period_close_date,
1047: fdp1.period_open_date,
1048: fdp1.calendar_period_open_date - 1
1049: FROM fa_Deprn_periods fdp1,
1050: fa_Deprn_periods fdp2
1051: WHERE fdp1.period_counter =
1052: (SELECT MIN(x.period_counter)
1053: FROM fa_Deprn_periods x
1054: WHERE x.fiscal_year = p_year

Line 1053: FROM fa_Deprn_periods x

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

Line 1059: FROM fa_Deprn_periods x

1055: AND x.book_type_code = p_asset_book
1056: )
1057: AND fdp2.period_counter =
1058: (SELECT MAX(x.period_counter)
1059: FROM fa_Deprn_periods x
1060: WHERE x.fiscal_year = p_year
1061: AND x.book_type_code = p_asset_book
1062: )
1063: AND fdp2.book_type_code = fdp1.book_type_code

Line 1074: FROM fa_deprn_periods fdp1

1070: P_Year VARCHAR2
1071: ) IS
1072: SELECT fdp1.CALENDAR_PERIOD_CLOSE_DATE,
1073: fdp1.period_counter
1074: FROM fa_deprn_periods fdp1
1075: WHERE fdp1.book_type_code = p_asset_book
1076: AND fdp1.fiscal_year = p_year
1077: AND fdp1.period_counter =
1078: (SELECT MAX(fdp.period_counter)

Line 1079: FROM fa_deprn_periods fdp

1075: WHERE fdp1.book_type_code = p_asset_book
1076: AND fdp1.fiscal_year = p_year
1077: AND fdp1.period_counter =
1078: (SELECT MAX(fdp.period_counter)
1079: FROM fa_deprn_periods fdp
1080: WHERE fdp.book_type_code = p_asset_book
1081: AND fdp.fiscal_year = p_year
1082: AND fdp.period_close_date IS NOT NULL
1083: );