[Home] [Help]
982: cursor c1 is
983: select 1
984: from sys.dual
985: where exists (SELECT NULL
986: FROM pa_cust_event_rev_dist_lines
987: where PROJECT_ID = x_PROJECT_ID
988: AND nvl(x_event_num, event_num) = event_num );
989:
990: cursor c2 is
990: cursor c2 is
991: select 1
992: from sys.dual
993: where exists (SELECT NULL
994: FROM pa_cust_event_rev_dist_lines
995: where project_id = x_proj_id
996: AND TASK_ID = x_TASK_ID
997: AND nvl(x_event_num, event_num) = event_num );
998: