APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on RA_GROUPING_RULES

Line 4658: hz_utility_v2pub.debug(p_message=>'grouping_rule_id is foreign key to ra_grouping_rules . ' ||

4654: p_column_value => p_customer_profile_rec.grouping_rule_id,
4655: x_return_status => x_return_status );
4656:
4657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4658: hz_utility_v2pub.debug(p_message=>'grouping_rule_id is foreign key to ra_grouping_rules . ' ||
4659: 'x_return_status = ' || x_return_status,
4660: p_prefix =>l_debug_prefix,
4661: p_msg_level=>fnd_log.level_statement);
4662: END IF;

Line 11614: FROM ra_grouping_rules gr

11610: l_dummy VARCHAR2(1);
11611:
11612: BEGIN
11613: SELECT 'Y' into l_dummy
11614: FROM ra_grouping_rules gr
11615: WHERE trunc(sysdate)
11616: BETWEEN gr.start_date AND
11617: nvl(gr.end_date,trunc(sysdate))
11618: AND gr.grouping_rule_id =

Line 11625: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_grouping_rules');

11621: WHEN NO_DATA_FOUND THEN
11622: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11623: FND_MESSAGE.SET_TOKEN( 'FK', 'grouping_rule_id' );
11624: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11625: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_grouping_rules');
11626: FND_MSG_PUB.ADD;
11627: x_return_status := FND_API.G_RET_STS_ERROR;
11628:
11629: END check_grouping_ruleid_fk;