DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORIES_B

Line 1294: from fa_categories_b c

1290: and p_def_dpis_dt between CBD.start_DPIS(+)
1291: and nvl(CBD.end_DPIS(+),p_def_dpis_dt)),
1292: inventorial =
1293: (select nvl(inventorial, 'YES')
1294: from fa_categories_b c
1295: where c.category_id(+) = gt.asset_category_id)
1296: where gt.book_type_code = p_book_type_code
1297: and gt.line_status = 'VALID'
1298: and gt.ledger_category_code = 'P'