APPS.PA_CUSTOMER_INFO dependencies on PA_PROJECT_TYPES

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 1145: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

1141: GROUP by pc.project_id;
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

Line 1206: pa_project_types b

1202: l_bill_another_project_flag VARCHAR2(1);
1203: CURSOR C1(c_project_id NUMBER) IS
1204: SELECT '1'
1205: FROM
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