APPS.CE_BNK_STMT_RECON_RPT_PKG SQL Statements

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

Line: 56

	SELECT	cibav.bank_account_name, cibav.currency_code
	INTO	gc_bank_account_name, gc_currency_code
	FROM	ce_internal_bank_accounts_v cibav
	WHERE	cibav.bank_account_id = P_BANK_ACCOUNT_ID;

Line: 61

	SELECT	csp.set_of_books_id
	INTO	gn_sob_id
	FROM	ce_system_parameters csp,
		ce_bank_accts_gt_v cbagv
	WHERE	csp.legal_entity_id = cbagv.account_owner_org_id
	AND	cbagv.bank_account_id = P_BANK_ACCOUNT_ID;

Line: 68

	SELECT  glp.start_date
	INTO	gc_from_date
	FROM	gl_period_statuses glp
	WHERE	glp.application_id = 101
	AND	glp.period_name = P_ACC_PERIOD_FROM
	AND	glp.set_of_books_id = gn_sob_id;

Line: 75

	SELECT  glp.end_date
	INTO	gc_to_date
	FROM	gl_period_statuses glp
	WHERE	glp.application_id = 101
	AND	glp.period_name = P_ACC_PERIOD_TO
	AND	glp.set_of_books_id = gn_sob_id;