eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASGMT_WFSTD dependencies on PA_PROJECT_CUSTOMERS

Line 4131: l_customer_id pa_project_customers.customer_id%TYPE;

4127: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4128: ,x_customer_name OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
4129: IS
4130:
4131: l_customer_id pa_project_customers.customer_id%TYPE;
4132: l_num_ids NUMBER;
4133:
4134: CURSOR l_check_one_cust_only_csr IS
4135: SELECT customer_id FROM pa_project_customers

Line 4135: SELECT customer_id FROM pa_project_customers

4131: l_customer_id pa_project_customers.customer_id%TYPE;
4132: l_num_ids NUMBER;
4133:
4134: CURSOR l_check_one_cust_only_csr IS
4135: SELECT customer_id FROM pa_project_customers
4136: WHERE project_id = p_project_id;
4137:
4138: /*
4139: CURSOR l_get_cust_csr IS

Line 4141: FROM pa_project_customers ppc,

4137:
4138: /*
4139: CURSOR l_get_cust_csr IS
4140: SELECT ppc.customer_id,rac.customer_name
4141: FROM pa_project_customers ppc,
4142: ra_customers rac
4143: WHERE ppc.project_id = p_project_id
4144: AND rac.customer_id = ppc.customer_id ;
4145: */