[Home] [Help]
162: l_path VARCHAR2(150);
163:
164: CURSOR c_get_fiscal_year IS
165: SELECT fiscal_year
166: FROM fa_deprn_periods
167: WHERE book_type_code = p_bookType
168: AND period_counter = p_period;
169:
170: BEGIN
569: RETURN BOOLEAN IS
570:
571: CURSOR c_period (cp_bookType VARCHAR2, cp_period VARCHAR2) IS
572: SELECT period_name
573: FROM fa_deprn_periods
574: WHERE Book_Type_Code = cp_bookType
575: AND period_counter = TO_NUMBER(cp_period);
576:
577: l_selOk BOOLEAN ;
686: fa_categories cf,
687: fa_asset_history ah,
688: fa_category_books cb,
689: fa_book_controls fb,
690: fa_deprn_periods fdp
691: WHERE ad.asset_id = bk.asset_id
692: AND cf.category_id = ah.category_id
693: AND cb.category_id = ah.category_id
694: AND bk.book_type_code = :v_bookType
766: fa_categories cf,
767: fa_asset_history ah,
768: fa_category_books cb,
769: fa_book_controls fb,
770: fa_deprn_periods fd,
771: fa_deprn_periods fdp
772: WHERE ad.asset_id = bk.asset_id
773: AND cf.category_id = ah.category_id
774: AND cb.category_id = ah.category_id
767: fa_asset_history ah,
768: fa_category_books cb,
769: fa_book_controls fb,
770: fa_deprn_periods fd,
771: fa_deprn_periods fdp
772: WHERE ad.asset_id = bk.asset_id
773: AND cf.category_id = ah.category_id
774: AND cb.category_id = ah.category_id
775: AND bk.book_Type_code = :v_bookType1
1091: fa_categories cf,
1092: fa_asset_history ah,
1093: fa_category_books cb,
1094: fa_book_controls fb,
1095: fa_deprn_periods fdp
1096: WHERE ad.asset_id = bk.asset_id
1097: AND cf.category_id = ah.category_id
1098: AND cb.category_id = ah.category_id
1099: AND bk.book_type_code = :v_bookType
1190: fa_categories cf,
1191: fa_asset_history ah,
1192: fa_category_books cb,
1193: fa_book_controls fb,
1194: fa_deprn_periods fd,
1195: fa_deprn_periods fdp
1196: WHERE ad.asset_id = bk.asset_id
1197: AND bk.transaction_header_id_out IS NULL
1198: AND cf.category_id = ah.category_id
1191: fa_asset_history ah,
1192: fa_category_books cb,
1193: fa_book_controls fb,
1194: fa_deprn_periods fd,
1195: fa_deprn_periods fdp
1196: WHERE ad.asset_id = bk.asset_id
1197: AND bk.transaction_header_id_out IS NULL
1198: AND cf.category_id = ah.category_id
1199: AND cb.category_id = ah.category_id
1595: gl_code_combinations cc,
1596: fa_categories cf,
1597: fa_category_books cb,
1598: fa_book_controls fb,
1599: fa_deprn_periods fdp,
1600: fa_asset_history ah
1601: WHERE ad.asset_id = bk.asset_id
1602: AND ah.asset_id = bk.asset_id
1603: AND cf.category_id=ah.category_id
1672: gl_code_combinations cc,
1673: fa_categories cf,
1674: fa_category_books cb,
1675: fa_book_controls fb,
1676: fa_deprn_periods fdp,
1677: fa_asset_history ah
1678: WHERE ad.asset_id = bk.asset_id
1679: AND ad.asset_id =dh.asset_id
1680: AND ah.asset_id = bk.asset_id
1983: gl_code_combinations cc,
1984: fa_categories cf,
1985: fa_category_books cb,
1986: fa_book_controls fb,
1987: fa_deprn_periods fdp,
1988: fa_asset_history ah
1989: WHERE ad.asset_id = bk.asset_id
1990: AND ah.asset_id = bk.asset_id
1991: AND cf.category_id=ah.category_id
2079: gl_code_combinations cc,
2080: fa_categories cf,
2081: fa_category_books cb,
2082: fa_book_controls fb,
2083: fa_deprn_periods fdp,
2084: fa_asset_history ah
2085: WHERE ad.asset_id = bk.asset_id
2086: AND ad.asset_id = id.asset_id
2087: AND ah.asset_id = bk.asset_id
2479: gl_code_combinations cc,
2480: fa_categories cf,
2481: fa_category_books cb,
2482: fa_book_controls fb,
2483: fa_deprn_periods fdp,
2484: fa_asset_history ah
2485: WHERE ad.asset_id = bk.asset_id
2486: AND ah.asset_id = bk.asset_id
2487: AND cf.category_id=ah.category_id
2558: gl_code_combinations cc,
2559: fa_categories cf,
2560: fa_category_books cb,
2561: fa_book_controls fb,
2562: fa_deprn_periods fdp,
2563: fa_asset_history ah
2564: WHERE ad.asset_id = dh.asset_id
2565: AND ah.asset_id = bk.asset_id
2566: AND cf.category_id=ah.category_id
2882: gl_code_combinations cc,
2883: fa_categories cf,
2884: fa_category_books cb,
2885: fa_book_controls fb,
2886: fa_deprn_periods fdp,
2887: fa_asset_history ah
2888: WHERE ad.asset_id = bk.asset_id
2889: AND ah.asset_id = bk.asset_id
2890: AND cf.category_id=ah.category_id
2979: gl_code_combinations cc,
2980: fa_categories cf,
2981: fa_category_books cb,
2982: fa_book_controls fb,
2983: fa_deprn_periods fdp,
2984: fa_asset_history ah
2985: WHERE ad.asset_id = dh.asset_id
2986: AND ah.asset_id = bk.asset_id
2987: AND cf.category_id=ah.category_id
3376: gl_code_combinations cc,
3377: fa_categories cf,
3378: fa_category_books cb,
3379: fa_book_controls fb,
3380: fa_deprn_periods fdp,
3381: fa_asset_history ah
3382: WHERE ad.asset_id = bk.asset_id
3383: AND ah.asset_id = bk.asset_id
3384: AND cf.category_id=ah.category_id
3456: gl_code_combinations cc,
3457: fa_categories cf,
3458: fa_category_books cb,
3459: fa_book_controls fb,
3460: fa_deprn_periods fdp,
3461: fa_asset_history ah
3462: WHERE ad.asset_id = dh.asset_id
3463: AND ah.asset_id = bk.asset_id
3464: AND cf.category_id=ah.category_id
3778: gl_code_combinations cc,
3779: fa_categories cf,
3780: fa_category_books cb,
3781: fa_book_controls fb,
3782: fa_deprn_periods fdp,
3783: fa_asset_history ah
3784: WHERE ad.asset_id = bk.asset_id
3785: AND ah.asset_id = bk.asset_id
3786: AND cf.category_id=ah.category_id
3875: gl_code_combinations cc,
3876: fa_categories cf,
3877: fa_category_books cb,
3878: fa_book_controls fb,
3879: fa_deprn_periods fdp,
3880: fa_asset_history ah
3881: WHERE ad.asset_id = dh.asset_id
3882: AND ah.asset_id = bk.asset_id
3883: AND cf.category_id=ah.category_id