APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on RA_GROUPING_RULES

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

4681: p_column_value => p_customer_profile_rec.grouping_rule_id,
4682: x_return_status => x_return_status );
4683:
4684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4685: hz_utility_v2pub.debug(p_message=>'grouping_rule_id is foreign key to ra_grouping_rules . ' ||
4686: 'x_return_status = ' || x_return_status,
4687: p_prefix =>l_debug_prefix,
4688: p_msg_level=>fnd_log.level_statement);
4689: END IF;

Line 11906: FROM ra_grouping_rules gr

11902: l_dummy VARCHAR2(1);
11903:
11904: BEGIN
11905: SELECT 'Y' into l_dummy
11906: FROM ra_grouping_rules gr
11907: WHERE trunc(sysdate)
11908: BETWEEN gr.start_date AND
11909: nvl(gr.end_date,trunc(sysdate))
11910: AND gr.grouping_rule_id =

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

11913: WHEN NO_DATA_FOUND THEN
11914: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11915: FND_MESSAGE.SET_TOKEN( 'FK', 'grouping_rule_id' );
11916: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11917: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_grouping_rules');
11918: FND_MSG_PUB.ADD;
11919: x_return_status := FND_API.G_RET_STS_ERROR;
11920:
11921: END check_grouping_ruleid_fk;