APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_V

Line 169: FROM Po_Requisition_Headers_V

165: ORDER BY a.tax_line_no; --new cursor added by pramasub for FP
166:
167: CURSOR Fetch_Hdr_Curr_Cur IS
168: SELECT NVL( Currency_Code, '$' )
169: FROM Po_Requisition_Headers_V
170: WHERE Requisition_Header_Id = v_requisition_header_id;
171:
172: --CURSOR Fetch_Uom_Code_Cur IS pramasub FP start
173: CURSOR Fetch_Uom_Code_Cur(cp_unit_of_meas VARCHAR2) IS /*4281841*/

Line 1151: * Removed cursors Fetch_Book_Id and used po_requisition_headers_v

1147: from JAI_PO_TAXES
1148: where line_location_id = cp_line_loc_id;
1149:
1150: /* Bug 5243532. Added by Lakshmi Gopalsami
1151: * Removed cursors Fetch_Book_Id and used po_requisition_headers_v
1152: * in cursor Hdr_Curr_Cur instead of gl_sets_of_books
1153: * and implemented using caching logic.
1154: */
1155: CURSOR Fetch_Hdr_Curr_Cur IS

Line 1157: FROM Po_Requisition_Headers_V

1153: * and implemented using caching logic.
1154: */
1155: CURSOR Fetch_Hdr_Curr_Cur IS
1156: SELECT NVL( Currency_Code, '$' )
1157: FROM Po_Requisition_Headers_V
1158: WHERE Requisition_Header_Id = v_requisition_header_id;
1159:
1160: --added, Bgowrava for Bug#6084636
1161: Cursor c_get_tax_modified_flag IS

Line 1950: FROM Po_Requisition_Headers_V

1946: FROM JAI_CMN_TAXES_ALL
1947: WHERE Tax_Id = p_tax_id;
1948:
1949: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
1950: FROM Po_Requisition_Headers_V
1951: WHERE Requisition_Header_Id = v_header_id;
1952:
1953: /* Bug 5243532. Addd by Lakshmi Gopalsami
1954: * Removed the cursor Fetch_Book_Id_Cur

Line 2784: FROM Po_Requisition_Headers_V

2780: FROM JAI_CMN_TAXES_ALL
2781: WHERE Tax_Id = p_tax_id;
2782:
2783: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
2784: FROM Po_Requisition_Headers_V
2785: WHERE Requisition_Header_Id = v_header_id;
2786:
2787: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
2788: FROM Mtl_Units_Of_Measure