APPS.JAI_PO_WF_UTIL_PUB dependencies on PO_RELEASES_ALL

Line 487: ln_po_header_id PO_RELEASES_ALL.PO_HEADER_ID%TYPE;

483: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
484: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
485: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
486: lv_modvat_flag VARCHAR2(1); --add by Xiao Lv for IL po notification on Mar-25-2009
487: ln_po_header_id PO_RELEASES_ALL.PO_HEADER_ID%TYPE;
488: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
489:
490: CURSOR Get_Req_tax_Cur
491: IS

Line 535: PO_RELEASES_ALL POA

531: IS
532: SELECT
533: POA.PO_HEADER_ID
534: FROM
535: PO_RELEASES_ALL POA
536: WHERE POA.PO_RELEASE_ID = pn_document_id;
537:
538:
539: lv_procedure_name VARCHAR2(40) := 'Get_Jai_Tax_Amount';

Line 1349: PO_RELEASES_ALL POA

1345: , JPT.tax_amount
1346: , JPT.currency
1347: , JPT.modvat_flag
1348: FROM
1349: PO_RELEASES_ALL POA
1350: , PO_LINE_LOCATIONS_ALL PLLA
1351: , JAI_PO_TAXES JPT
1352: WHERE PLLA.LINE_LOCATION_ID = JPT.LINE_LOCATION_ID
1353: AND POA.PO_HEADER_ID = PLLA.PO_HEADER_ID

Line 1671: , po_releases_all poa

1667: , DECODE(nvl(pol.closed_code, 'OPEN'), 'OPEN', NVL(poll.closed_code, 'OPEN'), pol.closed_code)
1668: FROM po_distributions pod
1669: , po_line_locations poll
1670: , po_lines pol
1671: , po_releases_all poa
1672: WHERE poa.po_release_id = p_document_id
1673: AND poll.po_release_id = p_document_id
1674: AND poll.po_line_id = pol.po_line_id
1675: AND pod.line_location_id = poll.line_location_id