APPS.ICX_ITEM_DIAG_PVT dependencies on DR$SQE

Line 499: select rownum,SQE_OWNER#,SQE_NAME,SQE_QUERY from ctxsys.dr$sqe

495: AND org_id = nvl(g_org_id,org_id)
496: order by po_line_id ,req_template_name,language , sequence;
497:
498: cursor sqe is
499: select rownum,SQE_OWNER#,SQE_NAME,SQE_QUERY from ctxsys.dr$sqe
500: where SQE_NAME in (
501: SELECT UPPER(decode( fnd_profile.value('REQUISITION_TYPE'),'INTERNAL','icxzi','PURCHASE','icxzp','icxzb') || SQE_SEQUENCE)
502: FROM
503: ICX_CAT_CONTENT_ZONES_B zoneb,

Line 863: elsif p_table_name = 'DR$SQE' then

859: p_col_num :=8;
860: p_row_num:=p_row_num-1;
861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
862:
863: elsif p_table_name = 'DR$SQE' then
864: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'8');
865: p_col_val(1):='ROWNUM';
866: p_col_val(2):='SQE_OWNER#';
867: p_col_val(3):='SQE_NAME';