50: INTO dummy
51: FROM sys.dual
52: WHERE exists (
53: SELECT NULL
54: FROM PA_PROJECT_CUSTOMERS
55: WHERE PROJECT_ID = x_project_id
56: GROUP BY PROJECT_ID
57: HAVING SUM(CUSTOMER_BILL_SPLIT) = 100);
58: --bug#10633080 - addition start
58: --bug#10633080 - addition start
59: ELSIF l_en_top_task_cust_flag <> 'Y' AND l_date_eff_funds_flag = 'Y' THEN
60: SELECT NULL
61: INTO dummy
62: FROM PA_PROJECT_CUSTOMERS
63: WHERE PROJECT_ID = x_project_id
64: AND rownum < 2;
65: --bug#10633080 - addition end
66: END IF;
93: INTO dummy
94: FROM sys.dual
95: WHERE exists (
96: SELECT NULL
97: FROM PA_PROJECT_CUSTOMERS CUST
98: WHERE CUST.PROJECT_ID = x_project_id
99: AND CUST.CUSTOMER_BILL_SPLIT > 0
100: AND NOT EXISTS (SELECT NULL
101: FROM PA_PROJECT_CONTACTS CONT