APPS.AMV_MATCH_PVT dependencies on AMV_C_AUTHORS

Line 1015: 'And exists (select 1 from amv_c_authors ca, jtf_amv_item_authors ia '||

1011: || ''' ) ';
1012: --
1013: IF (l_match_on_author_flag = FND_API.G_TRUE) THEN
1014: l_where_clause := l_where_clause ||
1015: 'And exists (select 1 from amv_c_authors ca, jtf_amv_item_authors ia '||
1016: 'where ca.channel_id = chan.channel_id ' ||
1017: 'and ia.item_id = item.item_id ' ||
1018: 'and ca.author = ia.author) ';
1019: END IF;

Line 1298: From amv_c_authors c, jtf_amv_item_authors i

1294: And item_type = l_item_type;
1295: --
1296: CURSOR Check_Author_Match_csr IS
1297: Select c.object_version_number
1298: From amv_c_authors c, jtf_amv_item_authors i
1299: Where c.channel_id = p_channel_id
1300: And i.item_id = p_item_id
1301: And i.author = c.author;
1302: --

Line 1535: 'And exists (select 1 from amv_c_authors ca, ' ||

1531: l_where_clause := 'Where item.item_id = :item_id ' ||
1532: 'And chan.channel_id = :channel_id ';
1533: IF (p_match_on_author_flag = FND_API.G_TRUE) THEN
1534: l_where_clause := l_where_clause ||
1535: 'And exists (select 1 from amv_c_authors ca, ' ||
1536: ' jtf_amv_item_authors ia ' ||
1537: 'where ca.channel_id = chan.channel_id ' ||
1538: 'and ia.item_id = item.item_id ' ||
1539: 'and ca.author = ia.author) ';