528: FROM rcv_shipment_lines rsl,
529: hr_locations hlo,
530: po_lookup_codes polc,
531: po_requisition_lines PRL, --
532: po_req_distributions PRD, --
534: pjm_projects_all_v PPA, --
535: pa_tasks_expend_v PTE --
536: WHERE polc.lookup_type = 'RCV DESTINATION TYPE'
852: X_progress := '134';
853:
854: SELECT project_id, task_id
855: INTO X_project_id, X_task_id
856: FROM po_req_distributions
857: WHERE distribution_id = x_req_distribution_id;
858:
859: exception
860: when no_data_found then