APPS.JAI_PO_HOOK_PKG dependencies on PO_HEADERS_ALL

Line 190: FROM po_headers_all

186: WHERE set_of_books_id = cp_sob_id;
187:
188: CURSOR cur_asbn_hdr(cp_header_id NUMBER) IS
189: SELECT *
190: FROM po_headers_all
191: WHERE po_header_id = cp_header_id;
192:
193: asbn_hdr_rec cur_asbn_hdr%ROWTYPE;
194:

Line 825: FROM po_headers_all

821: SELECT * FROM JAI_CMN_TAXES_ALL WHERE tax_id = cp_tax_id;
822:
823: CURSOR c_conv_rate_rfq(cp_header_id IN NUMBER) IS
824: SELECT rate, currency_code
825: FROM po_headers_all
826: WHERE po_header_id = cp_header_id;
827:
828: r_taxes c_tax_codes%ROWTYPE;
829: ln_conv_rate NUMBER;

Line 961: FROM po_headers_all

957: from rcv_transactions_interface
958: where HEADER_INTERFACE_ID = cp_hdr_intf_id;*/
959: SELECT rtxn.*,
960: (SELECT currency_code
961: FROM po_headers_all
962: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
963: (SELECT quantity
964: FROM po_line_locations_all
965: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY

Line 1266: FROM PO_HEADERS_ALL PHA

1262: -- pramasub end
1263:
1264: CURSOR c_conv_rate_asbn(cp_cmn_line_id IN NUMBER) IS
1265: SELECT PHA.rate, PHA.currency_code
1266: FROM PO_HEADERS_ALL PHA
1267: WHERE PHA.PO_HEADER_ID =
1268: (SELECT PO_HEADER_ID
1269: FROM JAI_CMN_LINES
1270: WHERE CMN_LINE_ID = cp_cmn_line_id);

Line 1817: FROM po_headers_all

1813:
1814: /* Get the conversion rate for the currency code for the PO / RFQ */
1815: CURSOR c_conv_rate_rfq(cp_header_id IN NUMBER) IS
1816: SELECT rate, currency_code
1817: FROM po_headers_all
1818: WHERE po_header_id = cp_header_id;
1819:
1820: /* Get Invoice amount*/
1821: CURSOR c_inv_amt IS

Line 2491: FROM po_headers_all pha

2487: CURSOR conv_rate_asbn_csr(cp_cmn_line_id IN NUMBER) IS
2488: SELECT
2489: pha.rate
2490: , pha.currency_code
2491: FROM po_headers_all pha
2492: WHERE pha.po_header_id =
2493: (SELECT po_header_id
2494: FROM jai_cmn_lines
2495: WHERE cmn_line_id = cp_cmn_line_id);

Line 2868: FROM po_headers_all

2864: CURSOR conv_rate_rfq_csr(pn_header_id IN NUMBER) IS
2865: SELECT
2866: rate
2867: , currency_code
2868: FROM po_headers_all
2869: WHERE po_header_id = pn_header_id;
2870:
2871: -- Get the shipments tax amount
2872: CURSOR shipments_tax_amt_csr IS