DBA Data[Home] [Help]

APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_APPROVAL_LIST_LINES

Line 3394: --Function: Delete records in PO_APPROVAL_LIST_LINES and

3390: --Modifies:
3391: -- FND Attachments related tables
3392: --Locks:
3393: -- None
3394: --Function: Delete records in PO_APPROVAL_LIST_LINES and
3395: -- PO_APPROVAL_LIST_HEADERS where reqs are purged
3396: --Parameters:
3397: --IN:
3398: --p_purge_entity

Line 3444: --SQL What: Delete PO_APPROVAL_LIST_LINES for the REQS being purged

3440:
3441: IF (p_purge_entity = 'REQ') THEN
3442: l_progress := '010';
3443:
3444: --SQL What: Delete PO_APPROVAL_LIST_LINES for the REQS being purged
3445: --SQL Why: These records should get purged together with the reqs
3446: DELETE
3447: FROM po_approval_list_lines PALL
3448: WHERE PALL.approval_list_header_id

Line 3447: FROM po_approval_list_lines PALL

3443:
3444: --SQL What: Delete PO_APPROVAL_LIST_LINES for the REQS being purged
3445: --SQL Why: These records should get purged together with the reqs
3446: DELETE
3447: FROM po_approval_list_lines PALL
3448: WHERE PALL.approval_list_header_id
3449: IN ( SELECT PALH.approval_list_header_id
3450: FROM po_approval_list_headers PALH,
3451: po_purge_req_list PPRL