APPS.AMV_MATCH_PVT dependencies on AMV_C_CHL_PERSPECTIVES

Line 1030: 'And exists (select 1 from amv_c_chl_perspectives cp, ' ||

1026: 'and ck.keyword = ik.keyword) ';
1027: END IF;
1028: IF (l_match_on_perspective_flag = FND_API.G_TRUE) THEN
1029: l_where_clause := l_where_clause ||
1030: 'And exists (select 1 from amv_c_chl_perspectives cp, ' ||
1031: 'amv_i_item_perspectives ip ' ||
1032: 'where cp.channel_id = chan.channel_id ' ||
1033: 'and ip.item_id = item.item_id ' ||
1034: 'and cp.perspective_id = ip.perspective_id) ';

Line 1312: From amv_c_chl_perspectives c, amv_i_item_perspectives i

1308: And i.keyword = c.keyword;
1309: --
1310: CURSOR Check_Perspective_Match_csr IS
1311: Select c.object_version_number
1312: From amv_c_chl_perspectives c, amv_i_item_perspectives i
1313: Where c.channel_id = p_channel_id
1314: And i.item_id = p_item_id
1315: And i.perspective_id = c.perspective_id;
1316: --

Line 1551: 'And exists (select 1 from amv_c_chl_perspectives cp, ' ||

1547: 'and ck.keyword = ik.keyword) ';
1548: END IF;
1549: IF (p_match_on_perspective_flag = FND_API.G_TRUE) THEN
1550: l_where_clause := l_where_clause ||
1551: 'And exists (select 1 from amv_c_chl_perspectives cp, ' ||
1552: 'amv_i_item_perspectives ip ' ||
1553: 'where cp.channel_id = chan.channel_id ' ||
1554: 'and ip.item_id = item.item_id ' ||
1555: 'and cp.perspective_id = ip.perspective_id) ';