APPS.CN_COMPGROUPS_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 115: jtf_rs_grp_relations.object_version_number%TYPE;

111: l_api_version CONSTANT NUMBER := 1.0;
112: l_group_relate_id number := 0;
113: l_relation_type varchar2 (30) := 'PARENT_GROUP';
114: l_object_version_number
115: jtf_rs_grp_relations.object_version_number%TYPE;
116: l_group_number jtf_rs_groups_b.group_number%TYPE;
117: l_parent_group_number jtf_rs_groups_b.group_number%TYPE;
118:
119: BEGIN

Line 140: FROM jtf_rs_grp_relations

136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: -- API body
138: SELECT group_relate_id, object_version_number
139: INTO l_group_relate_id, l_object_version_number
140: FROM jtf_rs_grp_relations
141: WHERE group_id = p_comp_group_rec.comp_group_id
142: AND related_group_id = p_comp_group_rec.parent_comp_group_id
143: AND start_date_active = p_comp_group_rec.comp_group_start_date
144: AND end_date_active = p_comp_group_rec.comp_group_end_date