APPS.IGIRX_C_IMP_IAC_REP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

           SELECT  max(period_counter)
           from fa_deprn_periods
           where book_type_code=p_dist_source_book;

Line: 32

           SELECT period_counter
           FROM igi_imp_iac_controls
           where book_type_code=p_book_type_code;

Line: 38

           SELECT count(*)
           FROM   fa_transaction_headers ft ,
                  fa_deprn_periods dp
           WHERE  ft.book_type_Code        = p_dist_source_book
           AND    dp.book_type_Code        = p_dist_source_book
           AND    dp.period_close_Date     IS NULL
           AND    ft.date_effective        >= dp.period_open_date ;

Line: 212

   	SELECT distribution_source_book INTO l_dist_source_book
	FROM fa_book_controls
	WHERE
	book_type_code=argument1;