APPS.IBW_OE_PVT dependencies on JTF_AMV_ITEMS_VL

Line 1931: l_template_name jtf_amv_items_vl.item_name%type;

1927: l_rec_count NUMBER (30);
1928: l_error_message VARCHAR2(240);
1929: l_template_access_name ibe_dsp_attachments_v.access_name%type;
1930: l_template_description ibe_dsp_attachments_v.description%type;
1931: l_template_name jtf_amv_items_vl.item_name%type;
1932: l_appctx VARCHAR2(30);
1933: l_url VARCHAR2(3000);
1934: BEGIN
1935: --find IF page matches AND then create page

Line 1944: FROM ibe_dsp_attachments_v dsp,jtf_amv_items_vl item

1940:
1941: BEGIN --Changed by Venky. Added code to handle no_data_found exception
1942: SELECT dsp.access_name,item.item_name,dsp.description
1943: INTO l_template_access_name ,l_template_name,l_template_description
1944: FROM ibe_dsp_attachments_v dsp,jtf_amv_items_vl item
1945: WHERE UPPER(url) LIKE '%/' || UPPER(file_name) || '%' --Changed by Venky
1946: AND item.item_id = dsp.logical_id
1947: AND ROWNUM = 1;
1948: