DBA Data[Home] [Help]

APPS.JAI_PO_PROC_PKG dependencies on PO_REQUISITION_HEADERS_V

Line 4121: FROM Po_Requisition_Headers_V

4117: (A.Org_Id is NULL AND v_org_id is NULL));
4118:
4119:
4120: CURSOR Fetch_Hdr_Curr_Cur IS SELECT NVL( Currency_Code, '$' )
4121: FROM Po_Requisition_Headers_V
4122: WHERE Requisition_Header_Id = v_header_id;
4123:
4124:
4125:

Line 4517: FROM Po_Requisition_Headers_V

4513: ORDER BY a.tax_line_no;
4514:
4515: CURSOR Fetch_Hdr_Curr_Cur(p_requisition_header_id NUMBER) IS
4516: SELECT NVL( Currency_Code, '$' )
4517: FROM Po_Requisition_Headers_V
4518: WHERE Requisition_Header_Id = r_req_line.requisition_header_id;
4519:
4520:
4521: CURSOR Fetch_Uom_Code_Cur(cp_unit_of_meas VARCHAR2) IS

Line 4974: FROM Po_Requisition_Headers_V

4970: where line_location_id = cp_line_loc_id;
4971:
4972: CURSOR Fetch_Hdr_Curr_Cur IS
4973: SELECT NVL( Currency_Code, '$' )
4974: FROM Po_Requisition_Headers_V
4975: WHERE Requisition_Header_Id = v_requisition_header_id;
4976:
4977: Cursor c_get_tax_modified_flag IS
4978: SELECT tax_modified_flag

Line 8402: FROM Po_Requisition_Headers_V

8398: where line_location_id = cp_line_loc_id;
8399:
8400: CURSOR Fetch_Hdr_Curr_Cur IS
8401: SELECT NVL( Currency_Code, '$' )
8402: FROM Po_Requisition_Headers_V
8403: WHERE Requisition_Header_Id = prec_po_req_line.REQUISITION_HEADER_ID;
8404:
8405: Cursor c_get_tax_modified_flag IS
8406: SELECT tax_modified_flag