APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_STATEMENT_CYCLES

Line 4379: ar_statement_cycles . ' || 'x_return_status = ' ||

4375: x_return_status => x_return_status );
4376:
4377: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4378: hz_utility_v2pub.debug(p_message=>'statement_cycle_id is foreign key to
4379: ar_statement_cycles . ' || 'x_return_status = ' ||
4380: x_return_status,
4381: p_prefix =>l_debug_prefix,
4382: p_msg_level=>fnd_log.level_statement);
4383: END IF;

Line 11478: FROM ar_statement_cycles sc

11474: l_dummy VARCHAR2(1);
11475:
11476: BEGIN
11477: SELECT 'Y' into l_dummy
11478: FROM ar_statement_cycles sc
11479: WHERE sc.status = 'A'
11480: AND sc.statement_cycle_id =
11481: p_column_value;
11482: EXCEPTION

Line 11487: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_statement_cycles');

11483: WHEN NO_DATA_FOUND THEN
11484: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11485: FND_MESSAGE.SET_TOKEN( 'FK', 'statement_cycle_id' );
11486: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11487: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_statement_cycles');
11488: FND_MSG_PUB.ADD;
11489: x_return_status := FND_API.G_RET_STS_ERROR;
11490:
11491: END check_stat_cycid_fk;