APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_MC_BOOK_CONTROLS

Line 122: from fa_mc_book_controls

118: -- Added an nvl to conversion_status to catch
119: -- the case when conversion_status is null
120: CURSOR check_conversion_status IS
121: select count(*)
122: from fa_mc_book_controls
123: where book_type_code = h_book
124: and nvl(conversion_status,' ') in ('S', 'R', 'E',' ')
125: and mrc_converted_flag = 'N'
126: and enabled_flag = 'Y';

Line 130: from fa_mc_book_controls mcbk

126: and enabled_flag = 'Y';
127:
128: CURSOR check_reporting_deprn_open IS
129: select count(1)
130: from fa_mc_book_controls mcbk
131: where mcbk.book_type_code = h_book
132: and (mcbk.deprn_status <> 'C' OR
133: ((mcbk.last_period_counter <> h_last_period_counter + 1) AND
134: (mcbk.last_period_counter <> h_last_period_counter)))

Line 139: from fa_mc_book_controls mcbk

135: and enabled_flag = 'Y';
136:
137: CURSOR check_reporting_deprn_close IS
138: select count(1)
139: from fa_mc_book_controls mcbk
140: where mcbk.book_type_code = h_book
141: and (mcbk.deprn_status <> 'C' OR
142: (mcbk.last_period_counter <> h_last_period_counter + 1))
143: and enabled_flag = 'Y';

Line 147: from fa_mc_book_controls mcbk

143: and enabled_flag = 'Y';
144:
145: CURSOR check_reporting_mass IS
146: select count(1)
147: from fa_mc_book_controls mcbk
148: where mcbk.book_type_code = h_book
149: and (mcbk.deprn_status <> 'C' OR
150: (mcbk.last_period_counter <> h_last_period_counter) OR
151: (mcbk.mass_request_id is not null))

Line 160: from fa_mc_book_controls mcbk

156: -- processed in faxcdr.
157:
158: CURSOR check_reporting_single IS
159: select count(1)
160: from fa_mc_book_controls mcbk
161: where mcbk.book_type_code = h_book
162: and (mcbk.deprn_status not in ('C', 'E') OR
163: (mcbk.last_period_counter <> h_last_period_counter) OR
164: (mcbk.mass_request_id is not null))

Line 1566: fa_mc_book_controls bc

1562: if (h_mc_source_flag = 'Y' and h_mrc_sob_type_code = 'P') then
1563: SELECT count(*)
1564: INTO h_count
1565: FROM fa_mc_deprn_periods dp,
1566: fa_mc_book_controls bc
1567: WHERE bc.book_type_code = X_book
1568: AND bc.book_type_code = dp.book_type_code
1569: AND bc.set_of_books_id = dp.set_of_books_id
1570: AND bc.enabled_flag = 'Y'

Line 1655: fa_mc_book_controls bc,

1651:
1652: SELECT count(*)
1653: INTO h_count
1654: FROM fa_mc_adjustments adj,
1655: fa_mc_book_controls bc,
1656: fa_mc_deprn_summary ds
1657: WHERE bc.book_type_code = X_book
1658: AND bc.enabled_flag = 'Y'
1659: AND adj.set_of_books_id = adj.set_of_books_id