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 5176: from dual

5172: fnd_global.resp_appl_id(),
5173: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5174: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5175: l_po_header_id_tbl(i)
5176: from dual
5177: where l_type_lookup_code_tbl(i) IN ('STANDARD', 'PLANNED');
5178:
5179: FORALL i in 1..l_po_release_id_tbl.count
5180: insert into zx_purge_transactions_gt(

Line 5191: from dual;

5187: fnd_global.resp_appl_id(),
5188: PO_CONSTANTS_SV.REL_ENTITY_CODE,
5189: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
5190: l_po_release_id_tbl(i)
5191: from dual;
5192:
5193:
5194: -- call ZX_API_PUB.PURGE_TAX_REPOSITORY in PURGE mode
5195: ZX_API_PUB.PURGE_TAX_REPOSITORY(