DBA Data[Home] [Help]

APPS.FA_INTERCO_PVT dependencies on FA_BOOK_CONTROLS

Line 1376: fa_book_controls bc,

1372: l_statement :=
1373: 'select distinct glcc.' || l_column_name ||
1374: ' from gl_code_combinations glcc,
1375: fa_books bk,
1376: fa_book_controls bc,
1377: fa_distribution_history dh
1378: where bk.asset_id = dh.asset_id
1379: and bk.group_asset_id = :p_asset_id
1380: and bk.book_type_code = bc.book_type_code

Line 1403: fa_book_controls bc,

1399:
1400: l_statement :=
1401: 'select distinct glcc.' || l_column_name ||
1402: ' from gl_code_combinations glcc,
1403: fa_book_controls bc,
1404: fa_distribution_history dh
1405: where dh.asset_id = :p_asset_Id
1406: and dh.date_ineffective is null
1407: and dh.code_combination_id = glcc.code_combination_id

Line 1423: fa_book_controls bc

1419: 'select distinct glcc.' || l_column_name ||
1420: ' from gl_code_combinations glcc,
1421: fa_books bk,
1422: fa_distribution_history dh,
1423: fa_book_controls bc
1424: where dh.asset_id = bk.group_asset_id
1425: and dh.date_ineffective is null
1426: and dh.code_combination_id = glcc.code_combination_id
1427: and bk.asset_id = :p_asset_id