APPS.FA_MC_UPG_SELECT_PKG SQL Statements

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

Line: 6

PROCEDURE main_select(
                        errbuf                  OUT NOCOPY     VARCHAR2,
                        retcode                 OUT NOCOPY     NUMBER,
			p_book_type_code 	IN	VARCHAR2,
			p_reporting_book	IN	VARCHAR2) IS

	X_start_pc		NUMBER;

Line: 33

	fa_rx_conc_mesg_pkg.log('Selecting Assets For Conversion from ');

Line: 90

                calling_fn => 'fa_mc_upg_select_pkg.main_select',
                name       => 'FA_SHARED_NUMBER_PROCESSED',
                token1     => 'NUMBER',
                value1     => to_char(X_total_assets));

Line: 96

		calling_fn => 'fa_mc_upg_select_pkg.main_select',
                name       => 'FA_SHARED_END_SUCCESS',
                token1     => 'PROGRAM',
                value1     => 'FAMRCUPG1');

Line: 122

			calling_fn => 'fa_mc_upg_select_pkg.main_select',
			name 	   => 'FA_SHARED_END_WITH_ERROR',
			token1	   => 'PROGRAM',
			value1     => 'FAMRCUPG1');

Line: 142

END main_select;