APPS.PO_CLM_UPG_PVT dependencies on PO_HEADERS_ALL

Line 171: po_headers_all poh

167: SELECT pod.draft_id
168: BULK COLLECT
169: INTO l_draft_id_tbl
170: FROM po_drafts pod,
171: po_headers_all poh
172: WHERE pod.document_id = poh.po_header_id
173: AND poh.style_id = p_style_id
174: AND pod.draft_type= 'MOD'
175: AND pod.status IN ('DRAFT','REJECTED','IN PROCESS',

Line 289: FROM po_headers_all_ext_b phbd

285: , l_temp_entity_name_tbl
286: , l_temp_entity_pk2_tbl
287: , l_temp_entity_pk3_tbl
288: , l_temp_entity_pk4_tbl
289: FROM po_headers_all_ext_b phbd
290: WHERE phbd.c_ext_attr40 ='PO_UDA_ADDRESS_TYPES'
291: -- multi-row attribute groups
292: AND EXISTS (SELECT 'Multi row attr grp'
293: FROM ego_fnd_dsc_flx_ctx_ext ag

Line 347: FROM PO_HEADERS_ALL phb

343: -- PO_DRAFTS.AGENT_ID
344:
345: UPDATE PO_HEADERS_DRAFT_ALL phd
346: SET phd.OLD_AMOUNT_LIMIT = ( SELECT phb.AMOUNT_LIMIT
347: FROM PO_HEADERS_ALL phb
348: WHERE phb.po_header_id=phd.po_header_id)
349: WHERE phd.draft_id=l_draft_id_tbl(i);
350: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_HEADERS_DRAFT_ALL'||SQL%ROWCOUNT);
351:

Line 375: FROM PO_HEADERS_ALL phb

371: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DISTRIBUTIONS_DRAFT_ALL'||SQL%ROWCOUNT);
372:
373: UPDATE PO_DRAFTS phd
374: SET phd.AGENT_ID = ( SELECT phb.AGENT_ID
375: FROM PO_HEADERS_ALL phb
376: WHERE phb.po_header_id=phd.document_id)
377: WHERE phd.draft_id=l_draft_id_tbl(i);
378: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DRAFTS'||SQL%ROWCOUNT);
379: