APPS.PO_DOC_STYLE_PVT dependencies on PO_HEADERS_ALL

Line 90: PO_HEADERS_ALL PH

86: PGT.CHAR1 destination_type,
87: PGT.CHAR2 purchase_basis,
88: PH.style_id source_doc_style_id
89: FROM PO_SESSION_GT PGT,
90: PO_HEADERS_ALL PH
91: WHERE PGT.KEY = p_session_gt_key
92: AND PGT.NUM2 = PH.PO_HEADER_ID
93: AND PGT.NUM2 IS NOT NULL;
94:

Line 202: po_headers_all poh

198: --Get the source doc styles and group by style id.
199: select poh.style_id BULK COLLECT
200: into l_style_id_tbl
201: from po_session_gt pgt,
202: po_headers_all poh
203: where pgt.key = p_session_gt_key
204: and pgt.num2 = poh.po_header_id
205: group by poh.style_id;
206:

Line 1058: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;

1054: d_module VARCHAR2(60) := 'po.plsql.PO_DOC_STYLE_PVT.get_style_display_name';
1055:
1056: l_style_display_name PO_DOC_STYLE_LINES_TL.DISPLAY_NAME%type;
1057: --Bug 14115069 Need to check if type is planned po
1058: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
1059:
1060: BEGIN
1061:
1062: d_progress := 0;

Line 1073: FROM PO_HEADERS_ALL

1069: d_progress := 10;
1070:
1071: SELECT type_lookup_code
1072: INTO l_type_lookup_code
1073: FROM PO_HEADERS_ALL
1074: WHERE po_header_id = p_doc_id;
1075:
1076: --Bug 14115069 Need to check if type is planned po
1077: IF(l_type_lookup_code <> 'PLANNED') THEN