APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_V

Line 163: FROM Po_Requisition_Headers_V

159: ORDER BY a.tax_line_no; --new cursor added by pramasub for FP
160:
161: CURSOR Fetch_Hdr_Curr_Cur IS
162: SELECT NVL( Currency_Code, '$' )
163: FROM Po_Requisition_Headers_V
164: WHERE Requisition_Header_Id = v_requisition_header_id;
165:
166: --CURSOR Fetch_Uom_Code_Cur IS pramasub FP start
167: CURSOR Fetch_Uom_Code_Cur(cp_unit_of_meas VARCHAR2) IS /*4281841*/

Line 1063: * Removed cursors Fetch_Book_Id and used po_requisition_headers_v

1059: from JAI_PO_TAXES
1060: where line_location_id = cp_line_loc_id;
1061:
1062: /* Bug 5243532. Added by Lakshmi Gopalsami
1063: * Removed cursors Fetch_Book_Id and used po_requisition_headers_v
1064: * in cursor Hdr_Curr_Cur instead of gl_sets_of_books
1065: * and implemented using caching logic.
1066: */
1067: CURSOR Fetch_Hdr_Curr_Cur IS

Line 1069: FROM Po_Requisition_Headers_V

1065: * and implemented using caching logic.
1066: */
1067: CURSOR Fetch_Hdr_Curr_Cur IS
1068: SELECT NVL( Currency_Code, '$' )
1069: FROM Po_Requisition_Headers_V
1070: WHERE Requisition_Header_Id = v_requisition_header_id;
1071:
1072: --added, Bgowrava for Bug#6084636
1073: Cursor c_get_tax_modified_flag IS

Line 1819: FROM Po_Requisition_Headers_V

1815: FROM JAI_CMN_TAXES_ALL
1816: WHERE Tax_Id = p_tax_id;
1817:
1818: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
1819: FROM Po_Requisition_Headers_V
1820: WHERE Requisition_Header_Id = v_header_id;
1821:
1822: /* Bug 5243532. Addd by Lakshmi Gopalsami
1823: * Removed the cursor Fetch_Book_Id_Cur

Line 2561: FROM Po_Requisition_Headers_V

2557: FROM JAI_CMN_TAXES_ALL
2558: WHERE Tax_Id = p_tax_id;
2559:
2560: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
2561: FROM Po_Requisition_Headers_V
2562: WHERE Requisition_Header_Id = v_header_id;
2563:
2564: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
2565: FROM Mtl_Units_Of_Measure