DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_EVENTS

Line 875: from pa_events e, pa_event_types et

871: FROM pa_cust_event_rev_dist_lines rdl
872: WHERE rdl.project_id = P_Project_ID
873: and exists /* check if the event is an automatic event */
874: (select 1
875: from pa_events e, pa_event_types et
876: where e.project_id = rdl.project_id
877: and e.event_num = rdl.event_num
878: and nvl(e.task_id,-99) = nvl(rdl.task_id,-99)
879: and e.event_type = et.event_type

Line 944: UPDATE pa_events

940:
941: END LOOP;
942:
943: /* Release One Time Event BILL Holds */
944: UPDATE pa_events
945: SET bill_hold_flag = 'N',
946: last_update_date = sysdate,
947: last_updated_by = P_User_ID,
948: last_update_login = P_Employee_ID