DBA Data[Home] [Help]

APPS.PA_RETENTION_PKG dependencies on PA_CUST_EVENT_REV_DIST_LINES

Line 2765: UPDATE PA_CUST_EVENT_REV_DIST_LINES

2761: WHERE PROJECT_ID = p_project_id
2762: AND DRAFT_INVOICE_NUM = draftinvoicenum
2763: AND DRAFT_INVOICE_ITEM_LINE_NUM = (NetZeroLineNum-NZCount+j); /* Modified for Bug 9690548 */
2764:
2765: UPDATE PA_CUST_EVENT_REV_DIST_LINES
2766: SET DRAFT_INVOICE_ITEM_LINE_NUM = LastLineNum
2767: WHERE PROJECT_ID = p_project_id
2768: AND DRAFT_INVOICE_NUM = draftinvoicenum
2769: AND DRAFT_INVOICE_ITEM_LINE_NUM = (NetZeroLineNum-NZCount+j); /* Modified for Bug 9690548 */