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 1256: FROM pa_project_customers

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

Line 5193: FROM pa_project_customers

5189:
5190: CURSOR l_customer_csr( p_project_id NUMBER )
5191: IS
5192: SELECT customer_id
5193: FROM pa_project_customers
5194: WHERE project_id = p_project_id;
5195:
5196: -- 4363092 TCA changes, replaced RA views with HZ tables
5197: /*

Line 11921: from pa_project_customers

11917: SELECT 'Y' FROM pa_tasks
11918: WHERE project_id = p_project_id
11919: AND parent_task_id IS NULL
11920: AND nvl(customer_id, -1) NOT IN (select customer_id
11921: from pa_project_customers
11922: where project_id=p_project_id);
11923:
11924: l_any_invalid_customer varchar2(1) :='N';
11925:

Line 11967: from pa_project_customers

11963: close any_invalid_customer;
11964:
11965: if l_any_invalid_customer = 'Y' then
11966: select count(*) into l_cust_count
11967: from pa_project_customers
11968: where project_id=p_project_id;
11969:
11970: if l_cust_count > 0 then
11971: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11988: from pa_project_customers

11984: --validation 2
11985: if (p_calling_context = 'UPDATE_PROJECT' and l_enable_tt_cust_flag = 'Y') then
11986: begin
11987: select 'Y' into valid_def_ttsk_cust
11988: from pa_project_customers
11989: where project_id=p_project_id
11990: and default_top_task_cust_flag='Y';
11991: exception
11992: when NO_DATA_FOUND then

Line 11995: from pa_project_customers

11991: exception
11992: when NO_DATA_FOUND then
11993:
11994: select count(*) into l_cust_count
11995: from pa_project_customers
11996: where project_id=p_project_id;
11997:
11998: if l_cust_count > 0 then
11999: x_return_status := FND_API.G_RET_STS_ERROR;