APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_CLASSES

Line 777: FROM PA_PROJECT_CLASSES

773: c_class_category VARCHAR2,
774: c_class_code VARCHAR2)
775: IS
776: SELECT 'x'
777: FROM PA_PROJECT_CLASSES
778: WHERE object_id = c_object_id
779: AND object_type = c_object_type
780: AND class_category = c_class_category
781: AND class_code = c_class_code;

Line 832: FROM PA_PROJECT_CLASSES_V PAC,

828: c_object_type VARCHAR2,
829: c_class_category VARCHAR2)
830: IS
831: SELECT 'x'
832: FROM PA_PROJECT_CLASSES_V PAC,
833: PA_CLASS_CATEGORIES PCC
834: WHERE PAC.object_id = c_object_id AND
835: PAC.object_type = c_object_type AND
836: PAC.class_category = c_class_category AND

Line 1219: FROM PA_PROJECT_CLASSES pc

1215:
1216: CURSOR get_sum
1217: IS
1218: SELECT sum(pc.code_percentage)
1219: FROM PA_PROJECT_CLASSES pc
1220: WHERE pc.object_id = p_object_id
1221: AND pc.object_type = p_object_type
1222: AND pc.class_category = p_class_category;
1223:

Line 1227: FROM PA_PROJECT_CLASSES pc

1223:
1224: CURSOR get_old_percentage
1225: IS
1226: SELECT pc.class_category, pc.code_percentage
1227: FROM PA_PROJECT_CLASSES pc
1228: WHERE rowid = p_rowid;
1229:
1230: BEGIN
1231: x_return_status := 'S';

Line 1375: pa_project_classes ppc

1371: CURSOR C1(c_object_id NUMBER, c_object_type VARCHAR2)
1372: IS
1373: SELECT pcc.class_category, mandatory_flag
1374: FROM pa_class_categories pcc,
1375: pa_project_classes ppc
1376: WHERE pcc.class_category <> ppc.class_category
1377: AND ppc.object_id = c_object_id
1378: AND ppc.object_type = c_object_type
1379: AND trunc(sysdate) between trunc(pcc.start_date_active)

Line 1594: FROM PA_PROJECT_CLASSES

1590: IS
1591: CURSOR C1(c_object_id NUMBER, c_object_type VARCHAR2, c_class_category VARCHAR2)
1592: IS
1593: SELECT class_code, code_percentage
1594: FROM PA_PROJECT_CLASSES
1595: WHERE object_id = c_object_id
1596: AND object_type = c_object_type
1597: AND class_category = c_class_category
1598: ORDER BY class_code;

Line 1652: FROM PA_PROJECT_CLASSES

1648: IS
1649: CURSOR C1
1650: IS
1651: SELECT sum(code_percentage)
1652: FROM PA_PROJECT_CLASSES
1653: WHERE object_id = p_object_id
1654: AND object_type = p_object_type
1655: AND class_category = p_class_category;
1656: