APPS.PO_PALT_ASSIGNMENTS dependencies on PO_DOC_STYLE_HEADERS

Line 587: l_par_auto_assign_role po_doc_style_headers.par_auto_assign_role%TYPE;

583: l_par_draft_id NUMBER;
584: l_document_id NUMBER;
585: l_par_req_header_id NUMBER;
586: l_assignment_buyer_id NUMBER;
587: l_par_auto_assign_role po_doc_style_headers.par_auto_assign_role%TYPE;
588: l_par_auto_assign_flag VARCHAR2(1);
589: x_assignment_no NUMBER;
590: BEGIN
591:

Line 610: FROM po_doc_style_headers ds,

606: SELECT NVL(ds.par_auto_assign_flag, 'N'),
607: ds.par_auto_assign_role
608: INTO l_par_auto_assign_flag,
609: l_par_auto_assign_role
610: FROM po_doc_style_headers ds,
611: po_headers_draft_all pohd
612: WHERE pohd.style_id = ds.style_id
613: AND pohd.draft_id = l_par_draft_id
614: AND pohd.po_header_id = l_document_id;