DBA Data[Home] [Help]

APPS.PA_PURGE_PUB dependencies on WF_ITEMS

Line 892: FROM wf_items wi

888: WHERE
889: a.item_type in ('PACANDID','PACOPR','PARADVWF','PARAPTEM','PARFIGEN','PAROVCNT','PAWFGPF','PAYPRJNT','PARMATRX','PAXWFHRU')
890: AND a.item_key NOT IN
891: (SELECT wi.item_key
892: FROM wf_items wi
893: WHERE wi.item_type IN ('PACANDID','PACOPR','PARADVWF','PARAPTEM','PARFIGEN','PAROVCNT','PAWFGPF','PAYPRJNT','PARMATRX','PAXWFHRU')
894: )
895: --bug#10238573 start
896: UNION

Line 909: FROM wf_items wi

905: and ntf.item_type = pwp.item_type
906: and ntf.item_key = pwp.item_key)
907: AND pwp.item_key NOT IN
908: (SELECT wi.item_key
909: FROM wf_items wi
910: WHERE wi.item_type = 'PAWFAAP')
911: --bug#10238573 end
912: ;
913: