APPS.PO_DRAFTS_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 1705: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;

1701: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
1702: ) IS
1703:
1704: l_num_records NUMBER;
1705: l_style_name PO_DOC_STYLE_HEADERS.style_name%TYPE;
1706:
1707: BEGIN
1708: update_permission_check
1709: ( p_calling_module => p_calling_module,

Line 3596: po_doc_style_headers podsh

3592: podsh.ame_transaction_type
3593: INTO l_new_ame_appr_id_req,
3594: l_ame_transaction_type
3595: FROM po_headers_all poh,
3596: po_doc_style_headers podsh
3597: WHERE poh.style_id = podsh.style_id
3598: AND NVL(podsh.change_process_type,'CHANGE_ORDER') <> 'MODIFICATION'
3599: AND podsh.ame_transaction_type IS NOT NULL
3600: AND poh.po_header_id = p_draft_info.po_header_id;

Line 3941: FROM po_doc_style_headers pdsh ,

3937: SELECT 'Y'
3938: INTO l_mod_flag
3939: FROM dual
3940: WHERE EXISTS(SELECT 'mod enabled po'
3941: FROM po_doc_style_headers pdsh ,
3942: po_headers_all poh
3943: WHERE pdsh.style_id=poh.style_id
3944: AND poh.po_header_id=p_po_header_id
3945: AND pdsh.change_process_type='MODIFICATION');