DBA Data[Home] [Help]

APPS.PO_AP_PURGE_PVT dependencies on DUAL

Line 3799: FROM dual

3795: -- we may end up inserting the same records multiple
3796: -- times.
3797: SELECT 'Y'
3798: INTO l_range_inserted
3799: FROM dual
3800: WHERE EXISTS (
3801: SELECT NULL
3802: FROM po_requisition_headers PRH,
3803: po_history_requisitions PHR

Line 4002: FROM dual

3998: -- we may end up inserting the same records multiple
3999: -- times.
4000: SELECT 'Y'
4001: INTO l_range_inserted
4002: FROM dual
4003: WHERE EXISTS (
4004: SELECT NULL
4005: FROM po_headers PH,
4006: po_history_pos PHP

Line 5178: from dual

5174: is pased when the tax lines are created. Same should be passed when they are deleted. */
5175: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5176: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5177: l_po_header_id_tbl(i)
5178: from dual
5179: where l_type_lookup_code_tbl(i) IN ('STANDARD', 'PLANNED');
5180:
5181: FORALL i in 1..l_po_release_id_tbl.count
5182: insert into zx_purge_transactions_gt(

Line 5195: from dual;

5191: is pased when the tax lines are created. Same should be passed when they are deleted. */
5192: PO_CONSTANTS_SV.REL_ENTITY_CODE,
5193: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
5194: l_po_release_id_tbl(i)
5195: from dual;
5196:
5197:
5198: -- call ZX_API_PUB.PURGE_TAX_REPOSITORY in PURGE mode
5199: ZX_API_PUB.PURGE_TAX_REPOSITORY(