APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on XMLSEQUENCE

Line 23: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY'))) v

19:
20: CURSOR oic_plan_copy IS
21: SELECT extract(value(v),'/OIC_PLAN_COPY') "CP"
22: FROM cn_copy_requests_all cr,
23: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY'))) v
24: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
25:
26: CURSOR oic_object_count IS
27: SELECT COUNT(extract(value(v),'/CnCompPlansVO'))

Line 29: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY/CnCompPlansVO'))) v

25:
26: CURSOR oic_object_count IS
27: SELECT COUNT(extract(value(v),'/CnCompPlansVO'))
28: FROM cn_copy_requests_all cr,
29: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY/CnCompPlansVO'))) v
30: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
31:
32: v_prefix cn_copy_requests_all.prefix_info%TYPE;
33: v_xml cn_copy_requests_all.file_content_xmltype%TYPE;