APPS.JAI_PO_HA_TRIGGER_PKG dependencies on PO_LINES_ALL

Line 17: from po_lines_all pol

13: */
14: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15: CURSOR c_check_osp_po_distrib is
16: select 1
17: from po_lines_all pol
18: where po_header_id = pr_new.po_header_id
19: and exists
20: (select 1
21: from po_line_types_b

Line 351: FROM Po_Lines_All

347: WHERE Po_Header_Id = v_po_hdr_id;
348:
349: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS
350: SELECT Item_Id
351: FROM Po_Lines_All
352: WHERE Po_Line_Id = Lineid;
353:
354: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS
355: SELECT Line_Location_Id

Line 361: FROM Po_Lines_All

357: WHERE Po_Line_Id = lineid;
358:
359: CURSOR Fetch_Dtls_Cur( lineid IN NUMBER ) IS
360: SELECT Quantity, Unit_Price, Unit_Meas_Lookup_Code
361: FROM Po_Lines_All
362: WHERE Po_Line_Id = lineid;
363:
364: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
365: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code