APPS.IGF_AW_GEN_004 dependencies on IBC_CITEMS_V

Line 1317: CURSOR c_att_id(cp_itm_id ibc_citems_v.citem_id%TYPE) IS

1313: SELECT document_id,name
1314: FROM igs_co_mapping_v
1315: WHERE map_id=p_list_id;
1316:
1317: CURSOR c_att_id(cp_itm_id ibc_citems_v.citem_id%TYPE) IS
1318: SELECT attach_fid
1319: FROM ibc_citems_v
1320: WHERE CITEM_ID = cp_itm_id;
1321:

Line 1319: FROM ibc_citems_v

1315: WHERE map_id=p_list_id;
1316:
1317: CURSOR c_att_id(cp_itm_id ibc_citems_v.citem_id%TYPE) IS
1318: SELECT attach_fid
1319: FROM ibc_citems_v
1320: WHERE CITEM_ID = cp_itm_id;
1321:
1322: --Cursor to check that if p_list_id represents a static or a dynamic person id group
1323: CURSOR c_file_name IS

Line 1349: l_attach_fid ibc_citems_v.attach_fid%TYPE;

1345: l_person_id NUMBER;
1346: l_count NUMBER DEFAULT 0;
1347: l_list_numb igs_co_mapping.document_id%TYPE;
1348: l_list_name igs_co_mapping_v.name%TYPE;
1349: l_attach_fid ibc_citems_v.attach_fid%TYPE;
1350: l_query_text VARCHAR2(32767);
1351: lv_sql_code NUMBER;
1352: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1353: