APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_LINES_ALL

Line 100: FROM Po_Lines_All

96: CURSOR cur_bpa_unit_measure(p_blanket_hdr IN NUMBER, p_blanket_line NUMBER) IS
97: SELECT unit_meas_lookup_code
98: FROM Po_Line_Locations_All
99: WHERE Po_Line_Id IN (SELECT Po_Line_Id
100: FROM Po_Lines_All
101: WHERE Po_Header_Id = p_blanket_hdr
102: AND Line_Num = p_blanket_line);
103: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
104:

Line 934: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;

930: v_ship_to_organization_id NUMBER;
931: v_ship_to_location_id NUMBER;
932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
933: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
934: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
935: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
936: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
937: -- End, Vijay Shankar for Bug# 3193592
938:

Line 941: FROM Po_Lines_All

937: -- End, Vijay Shankar for Bug# 3193592
938:
939: CURSOR Fetch_Unit_Measure_Cur IS
940: SELECT Unit_Meas_Lookup_Code
941: FROM Po_Lines_All
942: WHERE Po_Line_Id = v_po_line_id;
943:
944: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
945: SELECT Uom_Code