[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'VALID'
FROM gl_code_combinations glcc
WHERE glcc.code_combination_id = X_rtn_ccid
AND glcc.enabled_flag = 'Y'
AND nvl(glcc.end_date_active, h_val_date) >=
h_val_date;
SELECT nvl(ASSET_COST_ACCOUNT_CCID, -1),
nvl(ASSET_CLEARING_ACCOUNT_CCID, -1),
nvl(DEPRN_EXPENSE_ACCOUNT_CCID, -1),
nvl(DEPRN_RESERVE_ACCOUNT_CCID, -1),
nvl(CIP_COST_ACCOUNT_CCID, -1),
nvl(CIP_CLEARING_ACCOUNT_CCID, -1),
nvl(NBV_RETIRED_GAIN_CCID,-1),
nvl(NBV_RETIRED_LOSS_CCID,-1),
nvl(PROCEEDS_SALE_GAIN_CCID,-1),
nvl(PROCEEDS_SALE_LOSS_CCID,-1),
nvl(COST_REMOVAL_GAIN_CCID,-1),
nvl(COST_REMOVAL_LOSS_CCID,-1),
nvl(COST_REMOVAL_CLEARING_CCID,-1),
nvl(PROCEEDS_SALE_CLEARING_CCID,-1),
nvl(REVAL_RSV_GAIN_ACCOUNT_CCID, -1),
nvl(REVAL_RSV_LOSS_ACCOUNT_CCID, -1),
nvl(DEFERRED_EXP_ACCOUNT_CCID, -1),
nvl(DEFERRED_RSV_ACCOUNT_CCID, -1),
nvl(DEPRN_ADJ_ACCOUNT_CCID, -1),
nvl(REVAL_AMORT_ACCOUNT_CCID, -1),
nvl(REVAL_RSV_ACCOUNT_CCID, -1),
nvl(BONUS_EXP_ACCOUNT_CCID, -1),
nvl(BONUS_RSV_ACCOUNT_CCID, -1),
accounting_flex_structure
FROM FA_DISTRIBUTION_ACCOUNTS da,
FA_BOOK_CONTROLS bc
WHERE bc.book_type_code = X_book_type_code
AND da.book_type_code = bc.book_type_code
AND da.distribution_id = X_distribution_id;
SELECT 'VALID'
FROM gl_code_combinations glcc
WHERE glcc.code_combination_id = X_rtn_ccid
AND glcc.enabled_flag = 'Y'
AND nvl(glcc.end_date_active, X_validation_date) >=
X_validation_date;
fnd_msg_pub.delete_msg();