91: and exists
92: (
93: select 'x'
94: from gl_period_statuses ps,
95: fa_book_controls bc
96: where ps.application_id = 101
97: and ps.migration_status_code in ('P', 'U')
98: and bc.set_of_books_id = ps.set_of_books_id
99: and dp.book_type_code = bc.book_type_code
352:
353: cursor c_periods is
354: select bc.book_type_code, ps.period_name
355: from gl_period_statuses ps,
356: fa_book_controls bc
357: where ps.application_id = 101
358: and ps.migration_status_code in ('P', 'U')
359: and bc.set_of_books_id = ps.set_of_books_id;
360:
419: -----------------------------------------------------------------------
420:
421: select count(*)
422: into l_group_books
423: from fa_book_controls
424: where allow_group_deprn_flag = 'Y';
425:
426: ad_parallel_updates_pkg.initialize_rowid_range(
427: ad_parallel_updates_pkg.ROWID_RANGE,
548: and exists
549: (
550: select 'x'
551: from gl_period_statuses ps,
552: fa_book_controls bc
553: where ps.application_id = 101
554: and ps.migration_status_code in ('P', 'U')
555: and bc.set_of_books_id = ps.set_of_books_id
556: and dp.book_type_code = bc.book_type_code
566: and exists
567: (
568: select 'x'
569: from gl_period_statuses ps,
570: fa_book_controls bc
571: where ps.application_id = 101
572: and ps.migration_status_code in ('P', 'U')
573: and bc.set_of_books_id = ps.set_of_books_id
574: and dp.book_type_code = bc.book_type_code
612:
613: cursor c_periods is
614: select bc.book_type_code, ps.period_name
615: from gl_period_statuses ps,
616: fa_book_controls bc
617: where ps.application_id = 101
618: and ps.migration_status_code in ('P', 'U')
619: and bc.set_of_books_id = ps.set_of_books_id;
620:
639: and exists
640: (
641: select 'x'
642: from gl_period_statuses ps,
643: fa_book_controls bc
644: where ps.application_id = 101
645: and ps.migration_status_code in ('P', 'U')
646: and bc.set_of_books_id = ps.set_of_books_id
647: and dp.book_type_code = bc.book_type_code
852: select distinct nvl(xla_conversion_status,'N') xla_conversion_status
853: from fa_deprn_periods
854: where period_name = cp_period_name
855: and book_type_code in ( select book_type_code
856: from fa_book_controls
857: where set_of_books_id = cp_ledger_id )
858: order by xla_conversion_status
859: ;
860: BEGIN
919: AND ps.application_id = 101
920: AND (ps.ledger_id, ps.period_name) not in
921: (
922: SELECT DISTINCT fbc.set_of_books_id, fdp.period_name
923: FROM fa_deprn_periods fdp, fa_book_controls fbc
924: WHERE fdp.book_type_code = fbc.book_type_code
925: );
926:
927: COMMIT;
1004: and exists
1005: (
1006: select 'x'
1007: from gl_period_statuses ps,
1008: fa_book_controls bc
1009: where ps.application_id = 101
1010: and ps.migration_status_code in ('P', 'U')
1011: and bc.set_of_books_id = ps.set_of_books_id
1012: and dp.book_type_code = bc.book_type_code
1024: and exists
1025: (
1026: select 'x'
1027: from gl_period_statuses ps,
1028: fa_book_controls bc
1029: where ps.application_id = 101
1030: and ps.migration_status_code in ('P', 'U')
1031: and bc.set_of_books_id = ps.set_of_books_id
1032: and dp.book_type_code = bc.book_type_code