APPS.PO_LINES_DRAFT_PVT dependencies on PO_LINES_DRAFT_ALL

Line 98: FROM po_lines_draft_all PLD

94: SELECT l_key,
95: l_index_tbl(i)
96: FROM DUAL
97: WHERE EXISTS (SELECT 1
98: FROM po_lines_draft_all PLD
99: WHERE PLD.draft_id = p_draft_id_tbl(i)
100: AND PLD.po_line_id = NVL(p_po_line_id_tbl(i),
101: PLD.po_line_id)
102: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y');

Line 338: po_lines_draft_all POLD

334: INTO l_po_line_id_tbl,
335: l_price_break_lookup_code_tbl,
336: l_update_retro_date_flag_tbl
337: FROM po_lines_all POL,
338: po_lines_draft_all POLD
339: WHERE POLD.draft_id = p_draft_info.draft_id
340: AND POLD.po_line_id = POL.po_line_Id
341: AND NVL(POLD.delete_flag, 'N') = 'N'
342: AND NVL(POLD.change_accepted_flag, 'Y') = 'Y'

Line 355: UPDATE po_lines_draft_all

351: END IF;
352: END LOOP;
353:
354: FORALL i IN 1..l_po_line_id_tbl.COUNT
355: UPDATE po_lines_draft_all
356: SET retroactive_date = SYSDATE
357: WHERE draft_id = p_draft_info.draft_id
358: AND po_line_id = l_po_line_id_tbl(i)
359: AND l_update_retro_date_flag_tbl(i) = 'Y';

Line 440: FROM po_lines_draft_all PLD,

436: BULK COLLECT
437: INTO l_id_list,
438: l_del_flag_list,
439: l_txn_exists_list
440: FROM po_lines_draft_all PLD,
441: po_lines_all PL
442: WHERE PLD.draft_id = p_draft_info.draft_id
443: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
444: AND PLD.po_line_id = PL.po_line_id(+);