[Home] [Help]
40: CURSOR C IS
41: select max(cp.end_date)
42: from fa_calendar_periods cp,
43: fa_calendar_types ct,
44: fa_book_controls bc
45: where bc.book_type_code = X_book_type_code and
46: bc.date_ineffective is null and
47: ct.calendar_type = bc.prorate_calendar and
48: cp.calendar_type = ct.calendar_type and
84: (cp.end_date + 1 - cp.start_date) /
85: (fy.end_date + 1 - fy.start_date))),0) * 12, 0)
86: from fa_calendar_periods cp,
87: fa_calendar_types ct,
88: fa_book_controls bc,
89: fa_fiscal_year fy
90: where bc.book_type_code = X_book_type_code and
91: bc.date_ineffective is null and
92: ct.calendar_type = bc.prorate_calendar and
240: -- find corporate book
241: x_err_stage := 'find corporate book';
242:
243: select bc.book_type_code into ll_corp_book
244: from fa_books bk, fa_book_controls bc
245: where bc.book_class = 'CORPORATE'
246: and bk.asset_id = X_Asset_Id
247: and bk.book_type_code = bc.book_type_code
248: and bk.date_ineffective is null;
386:
387: select bc.book_type_code
388: into l_asset_hdr_rec.book_type_code
389: from fa_books bk,
390: fa_book_controls bc
391: where bk.asset_id = x_asset_id
392: and bk.book_type_code = bc.book_type_code
393: and bk.transaction_header_id_out is null
394: and bc.book_class = 'CORPORATE';
449: DH.ASSIGNED_TO,
450: DH.TRANSACTION_HEADER_ID_IN
451: FROM
452: FA_DISTRIBUTION_HISTORY DH,
453: FA_BOOK_CONTROLS BC
454: WHERE
455: DH.ASSET_ID = p_asset_id AND
456: DH.BOOK_TYPE_CODE = BC.DISTRIBUTION_SOURCE_BOOK AND
457: BC.BOOK_TYPE_CODE = p_book_type_code AND