APPS.PA_CUSTOMER_INFO dependencies on PA_PROJECTS

Line 187: From pa_project_types pt, pa_projects pa

183: AND cust_account_id = X_Ship_To_Customer_Id; --Bug#5872732
184:
185: Cursor Ic_billing IS
186: Select pt.CC_PRVDR_FLAG
187: From pa_project_types pt, pa_projects pa
188: where pa.project_type=pt.project_type
189: and pa.project_id=x_project_id;
190:
191: /* End For Bug 2731449 */

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

700: X_Err_Stack In Out NOCOPY Varchar2 ) is --File.Sql.39 bug 4440895
701:
702: l_dummy VARCHAR2(1); -- Added for Bug 3110489
703: /** Cursor added for Bug 3110489 **/
704: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,
705: c_customer_id pa_project_customers.customer_id%TYPE)
706: IS
707: Select 'Y' FROM pa_project_customers
708: WHERE project_id = c_project_id

Line 1134: from pa_projects_v

1130: -- File.sql.39 Bug 4633405 (For new API)
1131: return number is
1132: CURSOR c_prj IS
1133: select project_type_class_code,project_status_code
1134: from pa_projects_v
1135: where project_id = p_project_Id;
1136:
1137: CURSOR C IS
1138: SELECT sum(pc.customer_bill_split)

Line 1146: l_project_status_code pa_projects_all.project_status_code%TYPE;

1142:
1143:
1144: x_percentage NUMBER(15):=0;
1145: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
1146: l_project_status_code pa_projects_all.project_status_code%TYPE;
1147: Begin
1148: x_valid_proj_flag := false;
1149: IF p_project_id IS NOT NULL THEN
1150: OPEN c_prj;

Line 1210: FROM pa_projects_all

1206: pa_project_types b
1207: WHERE b.project_type_class_code = 'CONTRACT' AND
1208: b.project_type =
1209: (SELECT project_type
1210: FROM pa_projects_all
1211: WHERE project_id = c_project_id) AND
1212: (b.cc_prvdr_flag = 'N' OR b.cc_prvdr_flag is NULL);
1213: CURSOR C2(c_customer_id NUMBER) IS
1214: SELECT '1'