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