APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_CLASSES

Line 790: FROM PA_PROJECT_CLASSES

786: c_class_category VARCHAR2,
787: c_class_code VARCHAR2)
788: IS
789: SELECT 'x'
790: FROM PA_PROJECT_CLASSES
791: WHERE object_id = c_object_id
792: AND object_type = c_object_type
793: AND class_category = c_class_category
794: AND class_code = c_class_code;

Line 845: FROM PA_PROJECT_CLASSES_V PAC,

841: c_object_type VARCHAR2,
842: c_class_category VARCHAR2)
843: IS
844: SELECT 'x'
845: FROM PA_PROJECT_CLASSES_V PAC,
846: PA_CLASS_CATEGORIES PCC
847: WHERE PAC.object_id = c_object_id AND
848: PAC.object_type = c_object_type AND
849: PAC.class_category = c_class_category AND

Line 1232: FROM PA_PROJECT_CLASSES pc

1228:
1229: CURSOR get_sum
1230: IS
1231: SELECT sum(pc.code_percentage)
1232: FROM PA_PROJECT_CLASSES pc
1233: WHERE pc.object_id = p_object_id
1234: AND pc.object_type = p_object_type
1235: AND pc.class_category = p_class_category;
1236:

Line 1240: FROM PA_PROJECT_CLASSES pc

1236:
1237: CURSOR get_old_percentage
1238: IS
1239: SELECT pc.class_category, pc.code_percentage
1240: FROM PA_PROJECT_CLASSES pc
1241: WHERE rowid = p_rowid;
1242:
1243: BEGIN
1244: x_return_status := 'S';

Line 1388: pa_project_classes ppc

1384: CURSOR C1(c_object_id NUMBER, c_object_type VARCHAR2)
1385: IS
1386: SELECT pcc.class_category, mandatory_flag
1387: FROM pa_class_categories pcc,
1388: pa_project_classes ppc
1389: WHERE pcc.class_category <> ppc.class_category
1390: AND ppc.object_id = c_object_id
1391: AND ppc.object_type = c_object_type
1392: AND trunc(sysdate) between trunc(pcc.start_date_active)

Line 1607: FROM PA_PROJECT_CLASSES

1603: IS
1604: CURSOR C1(c_object_id NUMBER, c_object_type VARCHAR2, c_class_category VARCHAR2)
1605: IS
1606: SELECT class_code, code_percentage
1607: FROM PA_PROJECT_CLASSES
1608: WHERE object_id = c_object_id
1609: AND object_type = c_object_type
1610: AND class_category = c_class_category
1611: ORDER BY class_code;

Line 1665: FROM PA_PROJECT_CLASSES

1661: IS
1662: CURSOR C1
1663: IS
1664: SELECT sum(code_percentage)
1665: FROM PA_PROJECT_CLASSES
1666: WHERE object_id = p_object_id
1667: AND object_type = p_object_type
1668: AND class_category = p_class_category;
1669: