507: FROM rcv_shipment_lines rsl,
508: hr_locations hlo,
509: po_lookup_codes polc,
510: po_requisition_lines PRL, --
511: po_req_distributions PRD, --
513: pjm_projects_all_v PPA, --
514: pa_tasks_expend_v PTE --
515: WHERE polc.lookup_type = 'RCV DESTINATION TYPE'
850: X_progress := '134';
851:
852: SELECT project_id, task_id
853: INTO X_project_id, X_task_id
854: FROM po_req_distributions
855: WHERE distribution_id = x_req_distribution_id;
856:
857: exception
858: when no_data_found then