APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_JOB_ASSOCIATIONS

Line 208: l_job_name po_job_associations_tl.JOB_DESCRIPTION%TYPE;

204: IS
205:
206: l_progress varchar2(200);
207: l_req_line_id NUMBER;
208: l_job_name po_job_associations_tl.JOB_DESCRIPTION%TYPE;
209: l_contact_info PO_REQUISITION_LINES.CONTACT_INFORMATION%TYPE;
210: l_start_date DATE;
211: l_req_info VARCHAR2(100) := '';
212: l_cont_status PO_REQUISITION_LINES.CONTRACTOR_STATUS%TYPE;

Line 247: po_job_associations pja

243: INTO l_job_name, l_contact_info, l_start_date, l_req_info
244: FROM
245: po_requisition_headers_all prh,
246: po_requisition_lines_all prl,
247: po_job_associations pja
248: WHERE prl.requisition_line_id = l_req_line_id AND
249: prl.job_id = pja.job_id AND
250: prh.requisition_header_id = prl.requisition_header_id;
251: