APPS.CSTACDLS SQL Statements

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

Line: 4

PROCEDURE DELETE_SUMMARY_DETAILS(
 i_org_id               IN      NUMBER,
 i_del_period_id        IN      NUMBER,
 err_num                OUT NOCOPY     NUMBER,
 err_code               OUT NOCOPY     VARCHAR2,
 err_msg                OUT NOCOPY     VARCHAR2)

IS

	l_stmt_num		NUMBER;

Line: 19

	DELETE FROM MTL_PER_CLOSE_DTLS
	WHERE
	ORGANIZATION_ID		=	I_ORG_ID	AND
	ACCT_PERIOD_ID		=	I_DEL_PERIOD_ID;

Line: 26

	DELETE FROM MTL_PERIOD_SUMMARY
	WHERE
	ORGANIZATION_ID         =       I_ORG_ID        AND
        ACCT_PERIOD_ID          =       I_DEL_PERIOD_ID;

Line: 42

END DELETE_SUMMARY_DETAILS;