890: The Get_project_info_for_RcvTrx procedure is called in procedures
891: populate_project_info procedure.
892:
893: This procedure gets the project and task from po_req_distributions_all
894: via rcv_transactions table for the rcv_transaction_id in the
895: mtl_material_transactions_temp.
896: */
897: Procedure Get_project_info_for_RcvTrx(
898: x_Return_Status Out NOCOPY Varchar2,
908:
909: SELECT prd.project_id, prd.task_id
910: INTO l_req_project_id,l_req_task_id
911: FROM po_req_distributions_all prd,
912: rcv_transactions rcv
913: WHERE rcv.transaction_id = P_Rcv_Trx_Id
914: And prd.requisition_line_id = rcv.requisition_line_id;
915:
916: x_project_id := l_req_project_id;