APPS.PA_PROJECT_PUB dependencies on PA_CUSTOMERS_V

Line 384: FROM PA_CUSTOMERS_V

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

Line 5669: SELECT customer_name from PA_CUSTOMERS_V

5665: AND ppst.structure_type_id = pst.structure_type_id ;
5666: -- Added This cursor for Bug No 4689326
5667: CURSOR l_cur_customer_name(l_customer_id NUMBER)
5668: IS
5669: SELECT customer_name from PA_CUSTOMERS_V
5670: WHERE customer_id = l_customer_id;
5671:
5672: l_str_type VARCHAR2(150);
5673: --End : added for bug 3746912

Line 22356: SELECT customer_name from PA_CUSTOMERS_V

22352: AND default_top_task_cust_flag = 'Y';
22353: -- Added This cursor for Bug No 4689326
22354: CURSOR l_cur_customer_name(l_customer_id NUMBER)
22355: IS
22356: SELECT customer_name from PA_CUSTOMERS_V
22357: WHERE customer_id = l_customer_id;
22358: -- Added for bug 5242015
22359: CURSOR cur_top_task_customer_id (l_task_id NUMBER ) IS
22360: SELECT customer_id FROM pa_tasks