APPS.AMV_CHANNEL_PVT dependencies on AMV_C_CHANNELS_TL

Line 91: from amv_c_channels_b b, amv_c_channels_tl tl

87: x_error_token OUT NOCOPY VARCHAR2
88: ) IS
89: CURSOR Get_ChannelStatusByName is
90: select b.channel_id
91: from amv_c_channels_b b, amv_c_channels_tl tl
92: where tl.channel_name = p_channel_name
93: and tl.language = userenv('lang')
94: -- commented line below for bug no.2950840
95: --and b.channel_category_id = p_category_id

Line 342: , amv_c_channels_tl tl

338: b.attribute13,
339: b.attribute14,
340: b.attribute15
341: from amv_c_channels_b b
342: , amv_c_channels_tl tl
343: where b.channel_id = p_channel_id
344: and tl.language = userenv('lang')
345: and tl.channel_id = b.channel_id;
346: --

Line 6053: ', amv_c_channels_tl tl ';

6049: ' b.last_match_time, ' ||
6050: ' b.notification_interval_type, ' ||
6051: ' b.last_notification_time ' ||
6052: 'FROM amv_c_channels_b b ' ||
6053: ', amv_c_channels_tl tl ';
6054: --Construct SQL statement for getting totaL count
6055: l_sql_statement2 := 'Select count(*) ' ||
6056: 'FROM amv_c_channels_b b ' ||
6057: ', amv_c_channels_tl tl ';

Line 6057: ', amv_c_channels_tl tl ';

6053: ', amv_c_channels_tl tl ';
6054: --Construct SQL statement for getting totaL count
6055: l_sql_statement2 := 'Select count(*) ' ||
6056: 'FROM amv_c_channels_b b ' ||
6057: ', amv_c_channels_tl tl ';
6058: --Construct the WHERE clause
6059: IF (p_criteria_rec.channel_id <> FND_API.G_MISS_NUM) THEN
6060: l_where_clause := l_where_clause || l_keyword ||
6061: 'b.channel_id = ' || p_criteria_rec.channel_id;