DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_DRAFT_REVENUES

Line 843: UPDATE pa_draft_revenues dr

839:
840: BEGIN
841:
842: /* Releasing bill event based revenue */
843: UPDATE pa_draft_revenues dr
844: SET dr.last_update_date = sysdate,
845: dr.last_updated_by = P_User_ID,
846: dr.released_date = sysdate,
847: dr.last_update_login = P_Employee_ID

Line 861: UPDATE pa_draft_revenues dr

857:
858: /* Releasing Revenue based on Automatic Events which have both revenue and
859: invoice amounts -For bug 5401384 - base bug 5246804*/
860:
861: UPDATE pa_draft_revenues dr
862: SET dr.last_update_date = sysdate,
863: dr.last_updated_by = P_User_ID,
864: dr.released_date = sysdate,
865: dr.last_update_login = P_Employee_ID

Line 894: UPDATE pa_draft_revenues dr

890: /* End of Changes for bug 5401384 - Base Bug 5246804 */
891:
892:
893: /* Releasing Expenditure item based revenue */
894: UPDATE pa_draft_revenues dr
895: SET dr.last_update_date = sysdate,
896: dr.last_updated_by = P_User_ID,
897: dr.released_date = sysdate,
898: dr.last_update_login = P_Employee_ID