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 446: po_lines_draft_all POLD

442: INTO l_po_line_id_tbl,
443: l_price_break_lookup_code_tbl,
444: l_update_retro_date_flag_tbl
445: FROM po_lines_all POL,
446: po_lines_draft_all POLD
447: WHERE POLD.draft_id = p_draft_info.draft_id
448: AND POLD.po_line_id = POL.po_line_Id
449: AND NVL(POLD.delete_flag, 'N') = 'N'
450: AND NVL(POLD.change_accepted_flag, 'Y') = 'Y'

Line 463: UPDATE po_lines_draft_all

459: END IF;
460: END LOOP;
461:
462: FORALL i IN 1..l_po_line_id_tbl.COUNT
463: UPDATE po_lines_draft_all
464: SET retroactive_date = SYSDATE
465: WHERE draft_id = p_draft_info.draft_id
466: AND po_line_id = l_po_line_id_tbl(i)
467: AND l_update_retro_date_flag_tbl(i) = 'Y';

Line 548: FROM po_lines_draft_all PLD,

544: BULK COLLECT
545: INTO l_id_list,
546: l_del_flag_list,
547: l_txn_exists_list
548: FROM po_lines_draft_all PLD,
549: po_lines_all PL
550: WHERE PLD.draft_id = p_draft_info.draft_id
551: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
552: AND PLD.po_line_id = PL.po_line_id(+);