APPS.JAI_PO_HOOK_PKG dependencies on PO_HEADERS_ALL

Line 149: FROM po_headers_all

145: WHERE set_of_books_id = cp_sob_id;
146:
147: CURSOR cur_asbn_hdr(cp_header_id NUMBER) IS
148: SELECT *
149: FROM po_headers_all
150: WHERE po_header_id = cp_header_id;
151:
152: asbn_hdr_rec cur_asbn_hdr%ROWTYPE;
153:

Line 733: FROM po_headers_all

729: SELECT * FROM JAI_CMN_TAXES_ALL WHERE tax_id = cp_tax_id;
730:
731: CURSOR c_conv_rate_rfq(cp_header_id IN NUMBER) IS
732: SELECT rate, currency_code
733: FROM po_headers_all
734: WHERE po_header_id = cp_header_id;
735:
736: r_taxes c_tax_codes%ROWTYPE;
737: ln_conv_rate NUMBER;

Line 869: FROM po_headers_all

865: from rcv_transactions_interface
866: where HEADER_INTERFACE_ID = cp_hdr_intf_id;*/
867: SELECT rtxn.*,
868: (SELECT currency_code
869: FROM po_headers_all
870: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
871: (SELECT quantity
872: FROM po_line_locations_all
873: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY

Line 1137: FROM PO_HEADERS_ALL PHA

1133: -- pramasub end
1134:
1135: CURSOR c_conv_rate_asbn(cp_cmn_line_id IN NUMBER) IS
1136: SELECT PHA.rate, PHA.currency_code
1137: FROM PO_HEADERS_ALL PHA
1138: WHERE PHA.PO_HEADER_ID =
1139: (SELECT PO_HEADER_ID
1140: FROM JAI_CMN_LINES
1141: WHERE CMN_LINE_ID = cp_cmn_line_id);

Line 1680: FROM po_headers_all

1676:
1677: /* Get the conversion rate for the currency code for the PO / RFQ */
1678: CURSOR c_conv_rate_rfq(cp_header_id IN NUMBER) IS
1679: SELECT rate, currency_code
1680: FROM po_headers_all
1681: WHERE po_header_id = cp_header_id;
1682:
1683: /* Get Invoice amount*/
1684: CURSOR c_inv_amt IS

Line 2289: FROM po_headers_all pha

2285: CURSOR conv_rate_asbn_csr(cp_cmn_line_id IN NUMBER) IS
2286: SELECT
2287: pha.rate
2288: , pha.currency_code
2289: FROM po_headers_all pha
2290: WHERE pha.po_header_id =
2291: (SELECT po_header_id
2292: FROM jai_cmn_lines
2293: WHERE cmn_line_id = cp_cmn_line_id);

Line 2666: FROM po_headers_all

2662: CURSOR conv_rate_rfq_csr(pn_header_id IN NUMBER) IS
2663: SELECT
2664: rate
2665: , currency_code
2666: FROM po_headers_all
2667: WHERE po_header_id = pn_header_id;
2668:
2669: -- Get the shipments tax amount
2670: CURSOR shipments_tax_amt_csr IS