APPS.PO_VENDORMERGE_GRP dependencies on PO_DOC_STYLE_HEADERS

Line 125: FROM po_doc_style_headers pods

121: pohd.last_update_date = sysdate
122: WHERE pohd.vendor_id = p_dup_vendor_id
123: AND pohd.vendor_site_id = p_dup_vendor_site_id
124: AND NOT EXISTS (SELECT 'Exclude CLM Document'
125: FROM po_doc_style_headers pods
126: WHERE pods.style_id = pohd.style_id
127: AND NVL(pods.CLM_FLAG,'N') = 'Y')
128: AND EXISTS ( SELECT 'Exclude draft_type is not equal to MOD'
129: FROM po_drafts dft

Line 142: FROM po_doc_style_headers pods,

138: PGOA.last_updated_by = l_last_updated_by,
139: PGOA.last_update_login = FND_GLOBAL.login_id
140: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id
141: AND NOT EXISTS (SELECT 'Exclude CLM Document'
142: FROM po_doc_style_headers pods,
143: po_headers ph
144: WHERE pods.style_id = ph.style_id
145: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
146: AND NVL(pods.CLM_FLAG,'N') = 'Y')

Line 172: FROM po_doc_style_headers pods

168: last_update_date = SYSDATE
169: WHERE ph.vendor_id = p_dup_vendor_id
170: AND ph.vendor_site_id = p_dup_vendor_site_id
171: AND NOT EXISTS (SELECT 'CLM Document' --
172: FROM po_doc_style_headers pods
173: WHERE pods.style_id = ph.style_id
174: AND NVL(pods.CLM_FLAG,'N') = 'Y');
175:
176:

Line 199: FROM po_doc_style_headers pods

195: pha.vendor_site_id = p_vendor_site_id
196: WHERE pha.vendor_id = p_dup_vendor_id
197: AND pha.vendor_site_id = p_dup_vendor_site_id
198: AND NOT EXISTS (SELECT 'CLM Document' --
199: FROM po_doc_style_headers pods
200: WHERE pods.style_id = pha.style_id
201: AND NVL(pods.CLM_FLAG,'N') = 'Y');
202:
203: IF (PO_LOG.d_stmt) THEN

Line 349: FROM po_doc_style_headers pods,

345: PGOA.last_updated_by = l_last_updated_by,
346: PGOA.last_update_login = FND_GLOBAL.login_id
347: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id
348: AND NOT EXISTS (SELECT 'CLM Document' --
349: FROM po_doc_style_headers pods,
350: po_headers ph
351: WHERE pods.style_id = ph.style_id
352: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
353: AND NVL(pods.CLM_FLAG,'N') = 'Y');

Line 362: FROM po_doc_style_headers pods,

358: PGOA.last_updated_by = l_last_updated_by,
359: PGOA.last_update_login = FND_GLOBAL.login_id
360: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id
361: AND NOT EXISTS (SELECT 'CLM Document' --
362: FROM po_doc_style_headers pods,
363: po_headers ph
364: WHERE pods.style_id = ph.style_id
365: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
366: AND NVL(pods.CLM_FLAG,'N') = 'Y');