DBA Data[Home] [Help]

APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 289: lp_fa_book_controls := 'FA_BOOK_CONTROLS_MRC_V';

285: END IF;
286:
287: IF upper(p_mrcsobtype) = 'R'
288: THEN
289: lp_fa_book_controls := 'FA_BOOK_CONTROLS_MRC_V';
290: ELSE
291: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
292: END IF;
293:

Line 291: lp_fa_book_controls := 'FA_BOOK_CONTROLS';

287: IF upper(p_mrcsobtype) = 'R'
288: THEN
289: lp_fa_book_controls := 'FA_BOOK_CONTROLS_MRC_V';
290: ELSE
291: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
292: END IF;
293:
294: return (TRUE);
295: end;

Line 361: Function LP_FA_BOOK_CONTROLS_P return varchar2 is

357: Function PERIOD_TO_p return varchar2 is
358: Begin
359: return PERIOD_TO;
360: END;
361: Function LP_FA_BOOK_CONTROLS_P return varchar2 is
362: Begin
363: return LP_FA_BOOK_CONTROLS;
364: END;
365:

Line 363: return LP_FA_BOOK_CONTROLS;

359: return PERIOD_TO;
360: END;
361: Function LP_FA_BOOK_CONTROLS_P return varchar2 is
362: Begin
363: return LP_FA_BOOK_CONTROLS;
364: END;
365:
366:
367:

Line 413: from fa_book_controls

409: end if;
410: else
411: select set_of_books_id
412: into h_set_of_books_id
413: from fa_book_controls
414: where book_type_code = book;
415:
416: h_reporting_flag := 'P';
417: end if;

Line 879: from fa_book_controls

875: end if;
876: else
877: select set_of_books_id
878: into h_set_of_books_id
879: from fa_book_controls
880: where book_type_code = book;
881:
882: h_reporting_flag := 'P';
883: end if;

Line 2603: FA_BOOK_CONTROLS_MRC_V BC

2599: Distribution_Source_Book
2600: FROM
2601: FA_DEPRN_PERIODS_MRC_V P1,
2602: FA_DEPRN_PERIODS_MRC_V P2,
2603: FA_BOOK_CONTROLS_MRC_V BC
2604: WHERE
2605: BC.Book_Type_Code = Book
2606: AND
2607: P1.Book_Type_Code = Book AND

Line 2630: FA_BOOK_CONTROLS BC

2626: Distribution_Source_Book
2627: FROM
2628: FA_DEPRN_PERIODS P1,
2629: FA_DEPRN_PERIODS P2,
2630: FA_BOOK_CONTROLS BC
2631: WHERE
2632: BC.Book_Type_Code = Book
2633: AND
2634: P1.Book_Type_Code = Book AND