APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 1020: FROM pa_project_customers

1016:
1017: CURSOR l_customer_csr( p_project_id NUMBER )
1018: IS
1019: SELECT customer_id
1020: FROM pa_project_customers
1021: WHERE project_id = p_project_id;
1022:
1023: -- 4363092 TCA changes, replaced RA views with HZ tables
1024:

Line 1258: FROM pa_project_customers

1254: WHERE project_id = p_project_rec.project_id;
1255:
1256: CURSOR cur_get_def_top_task_cust IS
1257: SELECT customer_id
1258: FROM pa_project_customers
1259: WHERE project_id = p_project_rec.project_id
1260: AND default_top_task_cust_flag = 'Y';
1261:
1262:

Line 5391: FROM pa_project_customers

5387:
5388: CURSOR l_customer_csr( p_project_id NUMBER )
5389: IS
5390: SELECT customer_id
5391: FROM pa_project_customers
5392: WHERE project_id = p_project_id;
5393:
5394: -- 4363092 TCA changes, replaced RA views with HZ tables
5395: /*

Line 12284: from pa_project_customers

12280: SELECT 'Y' FROM pa_tasks
12281: WHERE project_id = p_project_id
12282: AND parent_task_id IS NULL
12283: AND nvl(customer_id, -1) NOT IN (select customer_id
12284: from pa_project_customers
12285: where project_id=p_project_id);
12286:
12287: l_any_invalid_customer varchar2(1) :='N';
12288:

Line 12330: from pa_project_customers

12326: close any_invalid_customer;
12327:
12328: if l_any_invalid_customer = 'Y' then
12329: select count(*) into l_cust_count
12330: from pa_project_customers
12331: where project_id=p_project_id;
12332:
12333: if l_cust_count > 0 then
12334: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12351: from pa_project_customers

12347: --validation 2
12348: if (p_calling_context = 'UPDATE_PROJECT' and l_enable_tt_cust_flag = 'Y') then
12349: begin
12350: select 'Y' into valid_def_ttsk_cust
12351: from pa_project_customers
12352: where project_id=p_project_id
12353: and default_top_task_cust_flag='Y';
12354: exception
12355: when NO_DATA_FOUND then

Line 12358: from pa_project_customers

12354: exception
12355: when NO_DATA_FOUND then
12356:
12357: select count(*) into l_cust_count
12358: from pa_project_customers
12359: where project_id=p_project_id;
12360:
12361: if l_cust_count > 0 then
12362: x_return_status := FND_API.G_RET_STS_ERROR;