APPS.PA_EVENTS_PKG dependencies on DUAL

Line 107: CURSOR C2 IS SELECT pa_events_s.nextval FROM sys.dual;

103: WHERE project_id = X_Project_Id
104: AND ( (task_id = X_Task_Id)
105: or (task_id is NULL and X_Task_Id is NULL))
106: AND event_num = X_Event_Num;
107: CURSOR C2 IS SELECT pa_events_s.nextval FROM sys.dual;
108:
109: BEGIN
110: if (X_Event_Id is NULL) then
111: OPEN C2;

Line 821: FROM sys.dual

817: RETURN VARCHAR2 IS
818: V_Is_Event_Processed VARCHAR2(1) := 'N';
819: CURSOR C_Invoiced IS
820: SELECT 'Y'
821: FROM sys.dual
822: WHERE EXISTS(
823: SELECT 'Event is on invoice item'
824: FROM pa_draft_invoice_items dii
825: WHERE dii.project_id = X_project_id

Line 831: FROM sys.dual

827: AND dii.event_num = X_Event_Num
828: );
829: CURSOR C_Revenue_Distributed IS
830: SELECT 'Y'
831: FROM sys.dual
832: WHERE EXISTS(
833: SELECT 'Event is on Revenue dist line'
834: FROM pa_cust_event_rev_dist_lines erdl
835: WHERE erdl.project_id = X_Project_Id