DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECT_CUSTOMERS

Line 54: FROM PA_PROJECT_CUSTOMERS

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

Line 62: FROM PA_PROJECT_CUSTOMERS

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;

Line 97: FROM PA_PROJECT_CUSTOMERS CUST

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