APPS.PO_TAX_INTERFACE_PVT dependencies on DUAL

Line 179: SELECT po_session_gt_s.NEXTVAL INTO l_po_session_gt_key FROM dual;

175: initialize_zx_gt_tables(); -- Wipe ZX GT tables clean
176: d_progress := 20;
177: initialize_global_error_record();
178: d_progress := 30;
179: SELECT po_session_gt_s.NEXTVAL INTO l_po_session_gt_key FROM dual;
180:
181: IF PO_LOG.d_stmt THEN
182: PO_LOG.stmt(d_module_base,d_progress,'l_po_session_gt_key='||l_po_session_gt_key);
183: END IF;

Line 651: FROM DUAL

647: SET zxhgt.event_type_code =
648: DECODE(zxhgt.event_class_code,
649: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
650: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
651: FROM DUAL
652: WHERE EXISTS
653: (SELECT 'Y'
654: FROM po_distributions_all pd
655: WHERE pd.po_header_id = zxhgt.trx_id

Line 665: FROM DUAL

661: PO_CONSTANTS_SV.PO_DISTRIBUTED
662: ),
663: --Release
664: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
665: FROM DUAL
666: WHERE EXISTS
667: (SELECT 'Y'
668: FROM po_distributions_all pd
669: WHERE pd.po_release_id = zxhgt.trx_id

Line 3289: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag

3285: ,pvs.vendor_site_id --ship_third_pty_acct_site_id
3286: ,pvs.vendor_site_id --bill_third_pty_acct_site_id
3287: ,pll.ship_to_organization_id --ship_to_party_id
3288: --Bug 5632300. Parameter to confirm that tax classification is overridden
3289: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3290: WHERE p_calling_program = 'PDOI'
3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

Line 3949: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag

3945: ,pvs.vendor_site_id --ship_third_pty_acct_site_id
3946: ,pvs.vendor_site_id --bill_third_pty_acct_site_id
3947: ,pll.ship_to_organization_id --ship_to_party_id
3948: --Bug 5632300. Parameter to confirm that tax classification is overridden
3949: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3950: WHERE p_calling_program = 'PDOI'
3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

Line 5119: FROM DUAL

5115:
5116: d_progress := 10;
5117:
5118: SELECT 'Y' INTO l_result
5119: FROM DUAL
5120: WHERE EXISTS
5121: (SELECT 'Y'
5122: FROM po_headers_all POH,
5123: po_lines_all POL,

Line 5146: FROM DUAL

5142:
5143: d_progress := 20;
5144:
5145: SELECT 'Y' INTO l_Result
5146: FROM DUAL
5147: WHERE EXISTS
5148: (SELECT 'Y'
5149: FROM po_releases_all POR,
5150: po_line_locations_all PLL,

Line 5167: FROM DUAL

5163:
5164: d_progress := 30;
5165:
5166: SELECT 'Y' INTO l_Result
5167: FROM DUAL
5168: WHERE EXISTS
5169: (SELECT 'Y'
5170: FROM po_requisition_headers_all PRH,
5171: po_requisition_lines_all PRL

Line 5473: FROM dual

5469: -1,
5470: 'N'
5471: -- Added the EXISTS clause so that only one row is inserted
5472: --into gt table even if there are multiple tax lines for each shipment
5473: FROM dual
5474: WHERE EXISTS
5475: (SELECT 'TAX LINES EXIST'
5476: FROM zx_lines zl
5477: -- Restrict to only rows that have corresponding tax lines

Line 5667: FROM dual

5663:
5664: BEGIN
5665: SELECT 'Y'
5666: INTO l_clear_tables
5667: FROM dual
5668: WHERE EXISTS
5669: (SELECT 'CLEAR'
5670: FROM zx_transaction_lines_gt zxlgt
5671: WHERE zxlgt.line_level_action <> 'DELETE');