APPS.PA_PROJECT_PUB dependencies on PA_CUSTOMERS_V

Line 385: FROM PA_CUSTOMERS_V

381: t_adj_on_std_inv varchar2(2);
382:
383: CURSOR l_check_org_csr(c_customer_id IN NUMBER) IS
384: SELECT PARTY_ID
385: FROM PA_CUSTOMERS_V
386: WHERE CUSTOMER_ID = c_customer_id
387: AND PARTY_TYPE = 'ORGANIZATION';
388:
389: --Project Structures

Line 5819: SELECT customer_name from PA_CUSTOMERS_V

5815: AND ppst.structure_type_id = pst.structure_type_id ;
5816: -- Added This cursor for Bug No 4689326
5817: CURSOR l_cur_customer_name(l_customer_id NUMBER)
5818: IS
5819: SELECT customer_name from PA_CUSTOMERS_V
5820: WHERE customer_id = l_customer_id;
5821:
5822: l_str_type VARCHAR2(150);
5823: --End : added for bug 3746912

Line 22823: SELECT customer_name from PA_CUSTOMERS_V

22819: AND default_top_task_cust_flag = 'Y';
22820: -- Added This cursor for Bug No 4689326
22821: CURSOR l_cur_customer_name(l_customer_id NUMBER)
22822: IS
22823: SELECT customer_name from PA_CUSTOMERS_V
22824: WHERE customer_id = l_customer_id;
22825: -- Added for bug 5242015
22826: CURSOR cur_top_task_customer_id (l_task_id NUMBER ) IS
22827: SELECT customer_id FROM pa_tasks