APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_PROJECTS

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 1029: pa_projects a,

1025: CURSOR C1(c_project_id NUMBER) IS
1026: SELECT '1'
1027: FROM
1028: /* Commented for Bug 2499051
1029: pa_projects a,
1030: */
1031: pa_project_types b
1032: WHERE b.project_type_class_code = 'CONTRACT' AND
1033: b.project_type =

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);

Line 1132: , pa_projects p

1128: -- Start of addition for bug 5554475
1129: select pt.cc_prvdr_flag
1130: into l_cc_prvdr_flag
1131: FROM pa_project_types pt
1132: , pa_projects p
1133: WHERE p.project_type = pt.project_type
1134: AND p.project_id = p_project_id
1135: AND p.org_id = pt.org_id;
1136: