DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_WARRANTIES

Line 2796: FROM fa_warranties w

2792: if p_warranty_id is not null then
2793:
2794: -- Validate warranty is in valid date
2795: SELECT count(w.warranty_id) INTO l_count
2796: FROM fa_warranties w
2797: WHERE w.warranty_id = p_warranty_id
2798: AND p_date_placed_in_service between
2799: nvl (w.start_date, p_date_placed_in_service) and
2800: nvl (w.end_date, p_date_placed_in_service);

Line 2813: fa_warranties w

2809: -- Validate warranty currency is correct
2810: SELECT count(w.warranty_id) INTO l_count
2811: FROM gl_sets_of_books glsob,
2812: fa_book_controls bc,
2813: fa_warranties w
2814: WHERE w.warranty_id = p_warranty_id
2815: AND bc.book_type_code = p_book_type_code
2816: AND bc.set_of_books_id = glsob.set_of_books_id
2817: AND glsob.currency_code =