1996: cursor c1 is
1997: SELECT 1
1998: FROM sys.dual
1999: where exists (SELECT NULL
2000: FROM pa_ind_rate_schedules
2001: WHERE project_id = x_project_id);
2002:
2003: cursor c2 is
2004: SELECT 1
2003: cursor c2 is
2004: SELECT 1
2005: FROM sys.dual
2006: where exists (SELECT NULL
2007: FROM pa_ind_rate_schedules
2008: WHERE TASK_ID = x_task_ID);
2009:
2010: c1_rec c1%rowtype;
2011: c2_rec c2%rowtype;