[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT fcb.asset_cost_acct
FROM fa_book_controls_sec fbcs
,fa_category_books fcb
,fa_additions_v fav
WHERE fbcs.book_type_code = fcb.book_type_code
AND fbcs.set_of_books_id = pn_ledger_id
AND fbcs.book_class IN ('CORPORATE', 'TAX')
AND fbcs.gl_posting_allowed_flag = 'YES'
AND fav.asset_category_id = fcb.category_id
AND fav.asset_type = 'CAPITALIZED'
AND fav.asset_id IN
(SELECT DISTINCT fdh.asset_id
FROM fa_distribution_history fdh
,fa_transaction_headers fth
WHERE fdh.asset_id = fth.asset_id
AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
AND EXISTS
(SELECT fdp.period_close_date
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
ld_end_date
AND fdp.period_close_date IS NOT NULL)
AND fdh.date_effective <
nvl((SELECT MAX(fdp.period_close_date)
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE)
AND (fdh.date_ineffective >
nvl((SELECT MAX(fdp.period_close_date)
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE) OR fdh.date_ineffective IS NULL)
AND EXISTS
(SELECT jclllbg.bal_seg_value
FROM ja_cn_ledger_le_bsv_gt jclllbg
WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
jclllbg.bal_seg_value
AND jclllbg.ledger_id = pn_ledger_id
AND jclllbg.legal_entity_id = pn_legal_entity_id))
ORDER BY fcb.asset_cost_acct;
SELECT DISTINCT fcb.impair_reserve_acct
FROM fa_book_controls_sec fbcs
,fa_category_books fcb
,fa_additions_v fav
WHERE fbcs.book_type_code = fcb.book_type_code
AND fbcs.set_of_books_id = pn_ledger_id
AND fbcs.book_class IN ('CORPORATE', 'TAX')
AND fbcs.gl_posting_allowed_flag = 'YES'
AND fav.asset_category_id = fcb.category_id
AND fav.asset_type = 'CAPITALIZED'
AND fav.asset_id IN
(SELECT DISTINCT fdh.asset_id
FROM fa_distribution_history fdh
,fa_transaction_headers fth
WHERE fdh.asset_id = fth.asset_id
AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
AND EXISTS
(SELECT fdp.period_close_date
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
ld_end_date
AND fdp.period_close_date IS NOT NULL)
AND fdh.date_effective <
nvl((SELECT MAX(fdp.period_close_date)
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE)
AND (fdh.date_ineffective >
nvl((SELECT MAX(fdp.period_close_date)
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE) OR fdh.date_ineffective IS NULL)
AND EXISTS
(SELECT jclllbg.bal_seg_value
FROM ja_cn_ledger_le_bsv_gt jclllbg
WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
jclllbg.bal_seg_value
AND jclllbg.ledger_id = pn_ledger_id
AND jclllbg.legal_entity_id = pn_legal_entity_id))
ORDER BY fcb.impair_reserve_acct;
SELECT DISTINCT fcb.deprn_reserve_acct
FROM fa_book_controls_sec fbcs
,fa_category_books fcb
,fa_additions_v fav
WHERE fbcs.book_type_code = fcb.book_type_code
AND fbcs.set_of_books_id = pn_ledger_id
AND fbcs.book_class IN ('CORPORATE', 'TAX')
AND fbcs.gl_posting_allowed_flag = 'YES'
AND fav.asset_category_id = fcb.category_id
AND fav.asset_type = 'CAPITALIZED'
AND fav.asset_id IN
(SELECT DISTINCT fdh.asset_id
FROM fa_distribution_history fdh
,fa_transaction_headers fth
WHERE fdh.asset_id = fth.asset_id
AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
AND EXISTS
(SELECT fdp.period_close_date
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
ld_end_date
AND fdp.period_close_date IS NOT NULL)
AND fdh.date_effective <
nvl((SELECT MAX(fdp.period_close_date)
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE)
AND (fdh.date_ineffective >
nvl((SELECT MAX(fdp.period_close_date)
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE) OR fdh.date_ineffective IS NULL)
AND EXISTS
(SELECT jclllbg.bal_seg_value
FROM ja_cn_ledger_le_bsv_gt jclllbg
WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
jclllbg.bal_seg_value
AND jclllbg.ledger_id = pn_ledger_id
AND jclllbg.legal_entity_id = pn_legal_entity_id))
ORDER BY fcb.deprn_reserve_acct;
SELECT start_date
INTO ld_start_date
FROM gl_period_statuses
WHERE ledger_id = pn_ledger_id
AND application_id = 101
AND period_name = pv_period_from
AND to_char(period_year) = pv_accounting_year;
SELECT end_date
INTO ld_end_date
FROM gl_period_statuses
WHERE ledger_id = pn_ledger_id
AND application_id = 101
AND period_name = pv_period_to
AND to_char(period_year) = pv_accounting_year;