DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_WARRANTIES

Line 3000: FROM fa_warranties w

2996: if p_warranty_id is not null then
2997:
2998: -- Validate warranty is in valid date
2999: SELECT count(w.warranty_id) INTO l_count
3000: FROM fa_warranties w
3001: WHERE w.warranty_id = p_warranty_id
3002: AND p_date_placed_in_service between
3003: nvl (w.start_date, p_date_placed_in_service) and
3004: nvl (w.end_date, p_date_placed_in_service);

Line 3017: fa_warranties w

3013: -- Validate warranty currency is correct
3014: SELECT count(w.warranty_id) INTO l_count
3015: FROM gl_sets_of_books glsob,
3016: fa_book_controls bc,
3017: fa_warranties w
3018: WHERE w.warranty_id = p_warranty_id
3019: AND bc.book_type_code = p_book_type_code
3020: AND bc.set_of_books_id = glsob.set_of_books_id
3021: AND glsob.currency_code =