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 4146: l_customer_id pa_project_customers.customer_id%TYPE;

4142: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4143: ,x_customer_name OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
4144: IS
4145:
4146: l_customer_id pa_project_customers.customer_id%TYPE;
4147: l_num_ids NUMBER;
4148:
4149: CURSOR l_check_one_cust_only_csr IS
4150: SELECT customer_id FROM pa_project_customers

Line 4150: SELECT customer_id FROM pa_project_customers

4146: l_customer_id pa_project_customers.customer_id%TYPE;
4147: l_num_ids NUMBER;
4148:
4149: CURSOR l_check_one_cust_only_csr IS
4150: SELECT customer_id FROM pa_project_customers
4151: WHERE project_id = p_project_id;
4152:
4153: /*
4154: CURSOR l_get_cust_csr IS

Line 4156: FROM pa_project_customers ppc,

4152:
4153: /*
4154: CURSOR l_get_cust_csr IS
4155: SELECT ppc.customer_id,rac.customer_name
4156: FROM pa_project_customers ppc,
4157: ra_customers rac
4158: WHERE ppc.project_id = p_project_id
4159: AND rac.customer_id = ppc.customer_id ;
4160: */