APPS.PO_PALT_ASSIGNMENTS dependencies on PO_HEADERS_ALL

Line 625: FROM po_headers_all

621: -- If auto assignmnet role exists on set up page, but not on Award, then by defalut assign it to buyer.
622: IF l_par_auto_assign_role = 'AWARD_ADMINISTRATOR' THEN
623: SELECT NVL(clm_award_administrator, agent_id)
624: INTO l_assignment_buyer_id
625: FROM po_headers_all
626: WHERE po_header_id = l_document_id;
627: ELSIF l_par_auto_assign_role = 'CONTRACT_OFFICER' THEN
628: SELECT NVL(clm_contract_officer, agent_id)
629: INTO l_assignment_buyer_id

Line 630: FROM po_headers_all

626: WHERE po_header_id = l_document_id;
627: ELSIF l_par_auto_assign_role = 'CONTRACT_OFFICER' THEN
628: SELECT NVL(clm_contract_officer, agent_id)
629: INTO l_assignment_buyer_id
630: FROM po_headers_all
631: WHERE po_header_id = l_document_id;
632: ELSIF l_par_auto_assign_role = 'BUYER' THEN
633: SELECT agent_id
634: INTO l_assignment_buyer_id

Line 635: FROM po_headers_all

631: WHERE po_header_id = l_document_id;
632: ELSIF l_par_auto_assign_role = 'BUYER' THEN
633: SELECT agent_id
634: INTO l_assignment_buyer_id
635: FROM po_headers_all
636: WHERE po_header_id = l_document_id;
637: ELSE
638: -- IF auto assign role is null, assign it to in priority to Award Administrator, Contracting
639: -- Officer , or Buyer

Line 646: FROM po_headers_all

642: NULL, agent_id,
643: clm_contract_officer)),
644: clm_award_administrator)
645: INTO l_assignment_buyer_id
646: FROM po_headers_all
647: WHERE po_header_id = l_document_id;
648: END IF;
649:
650: x_assignment_no := NULL;