APPS.PO_DOC_STYLE_HELPER dependencies on PO_DOC_STYLE_HEADERS

Line 20: FROM PO_DOC_STYLE_HEADERS

16: END IF;
17:
18: SELECT DECODE(NVL(CHANGE_PROCESS_TYPE,'CHANGE_ORDER'),'MODIFICATION','Y','N')
19: INTO l_is_formal_chng_req
20: FROM PO_DOC_STYLE_HEADERS
21: WHERE STYLE_ID = p_style_id;
22:
23: d_progress := 10;
24:

Line 51: FROM PO_DOC_STYLE_HEADERS

47: END IF;
48:
49: SELECT NVL(CLM_FLAG,'N')
50: INTO l_clm_flag
51: FROM PO_DOC_STYLE_HEADERS
52: WHERE STYLE_ID = p_style_id;
53:
54: d_progress := 10;
55: return l_clm_flag;

Line 81: FROM PO_DOC_STYLE_HEADERS pdsh, po_headers_all pha

77: END IF;
78:
79: SELECT NVL(CLM_FLAG,'N')
80: INTO l_clm_flag
81: FROM PO_DOC_STYLE_HEADERS pdsh, po_headers_all pha
82: WHERE pha.po_header_id = p_po_header_id
83: AND pha.STYLE_ID = pdsh.style_id;
84:
85: d_progress := 10;