DBA Data[Home] [Help]

APPS.PA_RETENTION_PKG dependencies on PA_CUST_EVENT_REV_DIST_LINES

Line 2731: UPDATE PA_CUST_EVENT_REV_DIST_LINES

2727: WHERE PROJECT_ID = p_project_id
2728: AND DRAFT_INVOICE_NUM = draftinvoicenum
2729: AND DRAFT_INVOICE_ITEM_LINE_NUM = NetZeroLineNum;
2730:
2731: UPDATE PA_CUST_EVENT_REV_DIST_LINES
2732: SET DRAFT_INVOICE_ITEM_LINE_NUM = LastLineNum
2733: WHERE PROJECT_ID = p_project_id
2734: AND DRAFT_INVOICE_NUM = draftinvoicenum
2735: AND DRAFT_INVOICE_ITEM_LINE_NUM = NetZeroLineNum;