APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on AR_STATEMENT_CYCLES

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

4402: x_return_status => x_return_status );
4403:
4404: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4405: hz_utility_v2pub.debug(p_message=>'statement_cycle_id is foreign key to
4406: ar_statement_cycles . ' || 'x_return_status = ' ||
4407: x_return_status,
4408: p_prefix =>l_debug_prefix,
4409: p_msg_level=>fnd_log.level_statement);
4410: END IF;

Line 11770: FROM ar_statement_cycles sc

11766: l_dummy VARCHAR2(1);
11767:
11768: BEGIN
11769: SELECT 'Y' into l_dummy
11770: FROM ar_statement_cycles sc
11771: WHERE sc.status = 'A'
11772: AND sc.statement_cycle_id =
11773: p_column_value;
11774: EXCEPTION

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

11775: WHEN NO_DATA_FOUND THEN
11776: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11777: FND_MESSAGE.SET_TOKEN( 'FK', 'statement_cycle_id' );
11778: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11779: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_statement_cycles');
11780: FND_MSG_PUB.ADD;
11781: x_return_status := FND_API.G_RET_STS_ERROR;
11782:
11783: END check_stat_cycid_fk;