APPS.AMV_MATCH_PVT dependencies on AMV_C_CONTENT_TYPES

Line 1038: 'And exists (select 1 from amv_c_content_types cc ' ||

1034: 'and cp.perspective_id = ip.perspective_id) ';
1035: END IF;
1036: IF (l_match_on_content_type_flag = FND_API.G_TRUE) THEN
1037: l_where_clause := l_where_clause ||
1038: 'And exists (select 1 from amv_c_content_types cc ' ||
1039: 'where cc.channel_id = chan.channel_id ' ||
1040: 'and cc.content_type_id = item.content_type_id) ';
1041: END IF;
1042: IF (l_match_on_item_type_flag = FND_API.G_TRUE) THEN

Line 1286: From amv_c_content_types

1282: where item_id = p_item_id;
1283: --
1284: CURSOR Check_ContentType_Match_csr(p_content_type_id IN NUMBER) IS
1285: Select object_version_number
1286: From amv_c_content_types
1287: Where channel_id = p_channel_id
1288: And content_type_id = p_content_type_id;
1289: --
1290: CURSOR Check_ItemType_Match_csr(p_item_type IN VARCHAR2) IS

Line 1559: 'And exists (select 1 from amv_c_content_types cc ' ||

1555: 'and cp.perspective_id = ip.perspective_id) ';
1556: END IF;
1557: IF (p_match_on_content_type_flag = FND_API.G_TRUE) THEN
1558: l_where_clause := l_where_clause ||
1559: 'And exists (select 1 from amv_c_content_types cc ' ||
1560: 'where cc.channel_id = chan.channel_id ' ||
1561: 'and cc.content_type_id = item.content_type_id) ';
1562: END IF;
1563: IF (p_match_on_item_type_flag = FND_API.G_TRUE) THEN