DBA Data[Home] [Help]

APPS.IGI_IAC_REVAL_INIT_STRUCT dependencies on IGI_IAC_ASSET_BALANCES

Line 334: from igi_iac_asset_balances

330: l_max_period_counter number := 0;
331: begin
332: select nvl(max(period_counter),0)
333: into l_max_period_counter
334: from igi_iac_asset_balances
335: where asset_id = fp_asset_id
336: and book_type_code = fp_book_type_code
337: and period_counter <= fp_period_counter
338: ;

Line 365: from igi_iac_asset_balances

361: else
362: begin
363: select *
364: into l_reval_params.reval_input_asset
365: from igi_iac_asset_balances
366: where asset_id = fp_asset_id
367: and book_type_code = fp_book_type_code
368: and period_counter = l_max_period_counter
369: ;

Line 657: from igi_iac_asset_balances

653: l_max_period_counter number := 0;
654: begin
655: select nvl(max(period_counter),0)
656: into l_max_period_counter
657: from igi_iac_asset_balances
658: where asset_id = fp_asset_id
659: and book_type_code = fp_book_type_code
660: and period_counter <= fp_period_counter
661: ;

Line 688: from igi_iac_asset_balances

684: else
685: begin
686: select *
687: into l_reval_params.reval_input_asset
688: from igi_iac_asset_balances
689: where asset_id = fp_asset_id
690: and book_type_code = fp_book_type_code
691: and period_counter = l_max_period_counter
692: ;