DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_AST_DPRTNS_V

Line 11077: FROM okx_ast_dprtns_v

11073: deprn_reserve - (deprn_reserve -(deprn_reserve*p_split_factor)),
11074: prior_fy_expense - (prior_fy_expense-(prior_fy_expense*p_split_factor)),
11075: bonus_ytd_deprn - (bonus_ytd_deprn-(bonus_ytd_deprn*p_split_factor)),
11076: bonus_deprn_reserve - (bonus_deprn_reserve-(bonus_deprn_reserve*p_split_factor))
11077: FROM okx_ast_dprtns_v
11078: WHERE asset_id = p_asset_id
11079: AND book_type_code = p_book_type_code
11080: AND deprn_run_date = (SELECT MAX(deprn_run_date)
11081: FROM okx_ast_dprtns_v

Line 11081: FROM okx_ast_dprtns_v

11077: FROM okx_ast_dprtns_v
11078: WHERE asset_id = p_asset_id
11079: AND book_type_code = p_book_type_code
11080: AND deprn_run_date = (SELECT MAX(deprn_run_date)
11081: FROM okx_ast_dprtns_v
11082: WHERE asset_id = p_asset_id
11083: AND book_type_code = p_book_type_code);
11084:
11085: --cursor to get asset distribution rec

Line 12305: FROM okx_ast_dprtns_v

12301: -- -1 * (deprn_reserve -(deprn_reserve*p_split_factor)),
12302: -1 * (prior_fy_expense-(prior_fy_expense*p_split_factor)),
12303: -1 * (bonus_ytd_deprn-(bonus_ytd_deprn*p_split_factor)),
12304: -1 * (bonus_deprn_reserve-(bonus_deprn_reserve*p_split_factor))
12305: FROM okx_ast_dprtns_v
12306: WHERE asset_id = p_asset_id
12307: AND book_type_code = p_book_type_code
12308: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12309: FROM okx_ast_dprtns_v

Line 12309: FROM okx_ast_dprtns_v

12305: FROM okx_ast_dprtns_v
12306: WHERE asset_id = p_asset_id
12307: AND book_type_code = p_book_type_code
12308: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12309: FROM okx_ast_dprtns_v
12310: WHERE asset_id = p_asset_id
12311: AND book_type_code = p_book_type_code);
12312:
12313:

Line 12323: FROM okx_ast_dprtns_v

12319: -- -1 * deprn_reserve,
12320: -1 * prior_fy_expense,
12321: -1 * bonus_ytd_deprn,
12322: -1 * bonus_deprn_reserve
12323: FROM okx_ast_dprtns_v
12324: WHERE asset_id = p_asset_id
12325: AND book_type_code = p_book_type_code
12326: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12327: FROM okx_ast_dprtns_v

Line 12327: FROM okx_ast_dprtns_v

12323: FROM okx_ast_dprtns_v
12324: WHERE asset_id = p_asset_id
12325: AND book_type_code = p_book_type_code
12326: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12327: FROM okx_ast_dprtns_v
12328: WHERE asset_id = p_asset_id
12329: AND book_type_code = p_book_type_code);
12330:
12331: --Bug# 4028371 :