APPS.FA_UPGHARNESS_PKG dependencies on FA_BOOK_CONTROLS

Line 68: fa_book_controls bc

64: and exists
65: (
66: select 'x'
67: from gl_period_statuses ps,
68: fa_book_controls bc
69: where ps.application_id = 101
70: and ps.migration_status_code in ('P', 'U')
71: and bc.set_of_books_id = ps.set_of_books_id
72: and dp.book_type_code = bc.book_type_code

Line 299: fa_book_controls bc

295:
296: cursor c_periods is
297: select bc.book_type_code, ps.period_name
298: from gl_period_statuses ps,
299: fa_book_controls bc
300: where ps.application_id = 101
301: and ps.migration_status_code in ('P', 'U')
302: and bc.set_of_books_id = ps.set_of_books_id;
303:

Line 366: from fa_book_controls

362: -----------------------------------------------------------------------
363:
364: select count(*)
365: into l_group_books
366: from fa_book_controls
367: where allow_group_deprn_flag = 'Y';
368:
369: ad_parallel_updates_pkg.initialize_rowid_range(
370: ad_parallel_updates_pkg.ROWID_RANGE,

Line 495: fa_book_controls bc

491: and exists
492: (
493: select 'x'
494: from gl_period_statuses ps,
495: fa_book_controls bc
496: where ps.application_id = 101
497: and ps.migration_status_code in ('P', 'U')
498: and bc.set_of_books_id = ps.set_of_books_id
499: and dp.book_type_code = bc.book_type_code

Line 513: fa_book_controls bc

509: and exists
510: (
511: select 'x'
512: from gl_period_statuses ps,
513: fa_book_controls bc
514: where ps.application_id = 101
515: and ps.migration_status_code in ('P', 'U')
516: and bc.set_of_books_id = ps.set_of_books_id
517: and dp.book_type_code = bc.book_type_code

Line 559: fa_book_controls bc

555:
556: cursor c_periods is
557: select bc.book_type_code, ps.period_name
558: from gl_period_statuses ps,
559: fa_book_controls bc
560: where ps.application_id = 101
561: and ps.migration_status_code in ('P', 'U')
562: and bc.set_of_books_id = ps.set_of_books_id;
563:

Line 586: fa_book_controls bc

582: and exists
583: (
584: select 'x'
585: from gl_period_statuses ps,
586: fa_book_controls bc
587: where ps.application_id = 101
588: and ps.migration_status_code in ('P', 'U')
589: and bc.set_of_books_id = ps.set_of_books_id
590: and dp.book_type_code = bc.book_type_code

Line 799: fa_book_controls bc

795: and exists
796: (
797: select 'x'
798: from gl_period_statuses ps,
799: fa_book_controls bc
800: where ps.application_id = 101
801: and ps.migration_status_code in ('P', 'U')
802: and bc.set_of_books_id = ps.set_of_books_id
803: and dp.book_type_code = bc.book_type_code

Line 819: fa_book_controls bc

815: and exists
816: (
817: select 'x'
818: from gl_period_statuses ps,
819: fa_book_controls bc
820: where ps.application_id = 101
821: and ps.migration_status_code in ('P', 'U')
822: and bc.set_of_books_id = ps.set_of_books_id
823: and dp.book_type_code = bc.book_type_code

Line 842: fa_book_controls bc

838: and (ledger_id, period_name) in
839: (
840: select bc.set_of_books_id, dp.period_name
841: from fa_deprn_periods dp,
842: fa_book_controls bc
843: where dp.xla_conversion_status in ('UA', 'UD', 'UT')
844: and bc.book_type_code = dp.book_type_code
845: union all
846: select bc.set_of_books_id, dp.period_name

Line 866: fa_book_controls bc

862: and not exists
863: (
864: select 'x'
865: from fa_deprn_periods dp,
866: fa_book_controls bc
867: where bc.book_type_code = dp.book_type_code
868: and bc.set_of_books_id = ps.ledger_id
869: and dp.period_name = ps.period_name
870: union all

Line 888: fa_book_controls bc

884: and exists
885: (
886: select 'x'
887: from fa_deprn_periods dp,
888: fa_book_controls bc
889: where bc.book_type_code = dp.book_type_code
890: and bc.set_of_books_id = ps.ledger_id
891: and dp.period_name = ps.period_name
892: and dp.xla_conversion_status is null