APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 1753: AND ( EXISTS ( SELECT 1 FROM po_lines_draft_all

1749: AND ple.draft_id = p_draft_id
1750: AND ple.attr_group_id = ptu.attribute_group_id
1751: )
1752: --Bug 13543817
1753: AND ( EXISTS ( SELECT 1 FROM po_lines_draft_all
1754: WHERE draft_id = p_draft_id
1755: AND po_line_id = pol.po_line_id
1756: )
1757: OR nvl(p_draft_id,-1) = -1

Line 21193: (l_draft_type = 'PAR' AND NOT EXISTS (SELECT 1 FROM po_lines_draft_all WHERE po_line_id = l_line_id_tbl(i)

21189: Decode(l_draft_type,'PAR','W',NULL) --WARNING FOR PAR and ERROR FOR OTHERS
21190: FROM DUAL --bug 16474947
21191: WHERE
21192: ( (l_draft_type <> 'PAR') OR
21193: (l_draft_type = 'PAR' AND NOT EXISTS (SELECT 1 FROM po_lines_draft_all WHERE po_line_id = l_line_id_tbl(i)
21194: AND draft_id = l_draft_id AND change_status = 'NEW'))
21195: );
21196: --CLM Phase 4: PAR Changes End.
21197: l_progress := '037';