APPS.PA_CUSTOMER_INFO dependencies on PA_PROJECTS_ALL

Line 695: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,

691: X_Err_Stack In Out NOCOPY Varchar2 ) is --File.Sql.39 bug 4440895
692:
693: l_dummy VARCHAR2(1); -- Added for Bug 3110489
694: /** Cursor added for Bug 3110489 **/
695: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,
696: c_customer_id pa_project_customers.customer_id%TYPE)
697: IS
698: Select 'Y' FROM pa_project_customers
699: WHERE project_id = c_project_id

Line 1137: l_project_status_code pa_projects_all.project_status_code%TYPE;

1133:
1134:
1135: x_percentage NUMBER(15):=0;
1136: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
1137: l_project_status_code pa_projects_all.project_status_code%TYPE;
1138: Begin
1139: x_valid_proj_flag := false;
1140: IF p_project_id IS NOT NULL THEN
1141: OPEN c_prj;

Line 1201: FROM pa_projects_all

1197: pa_project_types b
1198: WHERE b.project_type_class_code = 'CONTRACT' AND
1199: b.project_type =
1200: (SELECT project_type
1201: FROM pa_projects_all
1202: WHERE project_id = c_project_id) AND
1203: (b.cc_prvdr_flag = 'N' OR b.cc_prvdr_flag is NULL);
1204: CURSOR C2(c_customer_id NUMBER) IS
1205: SELECT '1'