APPS.PO_TAX_INTERFACE_PVT dependencies on DUAL

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

167: initialize_zx_gt_tables(); -- Wipe ZX GT tables clean
168: d_progress := 20;
169: initialize_global_error_record();
170: d_progress := 30;
171: SELECT po_session_gt_s.NEXTVAL INTO l_po_session_gt_key FROM dual;
172:
173: IF PO_LOG.d_stmt THEN
174: PO_LOG.stmt(d_module_base,d_progress,'l_po_session_gt_key='||l_po_session_gt_key);
175: END IF;

Line 586: FROM DUAL

582: SET zxhgt.event_type_code =
583: DECODE(zxhgt.event_class_code,
584: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
585: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
586: FROM DUAL
587: WHERE EXISTS
588: (SELECT 'Y'
589: FROM po_distributions_all pd
590: WHERE pd.po_header_id = zxhgt.trx_id

Line 600: FROM DUAL

596: PO_CONSTANTS_SV.PO_DISTRIBUTED
597: ),
598: --Release
599: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'Y'
603: FROM po_distributions_all pd
604: WHERE pd.po_release_id = zxhgt.trx_id

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

3094: ,pvs.vendor_site_id --ship_third_pty_acct_site_id
3095: ,pvs.vendor_site_id --bill_third_pty_acct_site_id
3096: ,pll.ship_to_organization_id --ship_to_party_id
3097: --Bug 5632300. Parameter to confirm that tax classification is overridden
3098: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3099: WHERE p_calling_program = 'PDOI'
3100: AND pll.tax_name IS NOT NULL)
3101: ,pll.ship_to_organization_id --Bug#6902111
3102: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

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

3658: ,prl.line_num --trx_line_number
3659: ,prl.item_description --trx_line_description
3660: ,prl.item_description --product_description
3661: --Bug 5632300. Parameter to confirm that tax classification is overridden
3662: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3663: WHERE p_calling_program = 'REQIMPORT'
3664: AND prl.tax_name IS NOT NULL)
3665: ,prl.destination_organization_id --Bug#6902111
3666: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

Line 4226: FROM DUAL

4222:
4223: d_progress := 10;
4224:
4225: SELECT 'Y' INTO l_result
4226: FROM DUAL
4227: WHERE EXISTS
4228: (SELECT 'Y'
4229: FROM po_headers_all POH,
4230: po_lines_all POL,

Line 4253: FROM DUAL

4249:
4250: d_progress := 20;
4251:
4252: SELECT 'Y' INTO l_Result
4253: FROM DUAL
4254: WHERE EXISTS
4255: (SELECT 'Y'
4256: FROM po_releases_all POR,
4257: po_line_locations_all PLL,

Line 4274: FROM DUAL

4270:
4271: d_progress := 30;
4272:
4273: SELECT 'Y' INTO l_Result
4274: FROM DUAL
4275: WHERE EXISTS
4276: (SELECT 'Y'
4277: FROM po_requisition_headers_all PRH,
4278: po_requisition_lines_all PRL

Line 4578: FROM dual

4574: -1,
4575: 'N'
4576: -- Added the EXISTS clause so that only one row is inserted
4577: --into gt table even if there are multiple tax lines for each shipment
4578: FROM dual
4579: WHERE EXISTS
4580: (SELECT 'TAX LINES EXIST'
4581: FROM zx_lines zl
4582: -- Restrict to only rows that have corresponding tax lines

Line 4772: FROM dual

4768:
4769: BEGIN
4770: SELECT 'Y'
4771: INTO l_clear_tables
4772: FROM dual
4773: WHERE EXISTS
4774: (SELECT 'CLEAR'
4775: FROM zx_transaction_lines_gt zxlgt
4776: WHERE zxlgt.line_level_action <> 'DELETE');