APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_PROJECTS_ALL

Line 928: FROM pa_projects_all

924: SELECT cc_prvdr_flag
925: FROM pa_project_types
926: WHERE project_type =
927: (SELECT project_type
928: FROM pa_projects_all
929: WHERE project_id = c_project_id);
930:
931: /* Changed the having condition to the where condition in the following cursor c2
932: to avoid full table scan of pa_project_customers -Bug 2782177 */

Line 1035: FROM pa_projects_all

1031: pa_project_types b
1032: WHERE b.project_type_class_code = 'CONTRACT' AND
1033: b.project_type =
1034: (SELECT project_type
1035: FROM pa_projects_all
1036: WHERE project_id = c_project_id) AND
1037: (b.cc_prvdr_flag = 'N' OR b.cc_prvdr_flag is NULL);
1038: CURSOR C2(c_customer_id NUMBER) IS
1039: SELECT '1'

Line 1113: FROM pa_projects_all

1109: l_mcb_flag VARCHAR2(1);
1110: l_cc_prvdr_flag VARCHAR2(1); --bug#5554475
1111: CURSOR C1(c_project_id NUMBER) IS
1112: SELECT project_currency_code, multi_currency_billing_flag
1113: FROM pa_projects_all
1114: WHERE project_id = c_project_id;
1115: BEGIN
1116: -- bug 2070847
1117: open C1(p_project_id);