DBA Data[Home] [Help]

APPS.PA_USER_ATTR_PVT dependencies on PA_CLASS_CATEGORIES

Line 83: PA_CLASS_CATEGORIES pcc,

79: UNION
80: SELECT DISTINCT assocs.attr_group_id
81: FROM EGO_OBJ_AG_ASSOCS_B assocs,
82: PA_PROJECT_CLASSES ppc,
83: PA_CLASS_CATEGORIES pcc,
84: FND_OBJECTS obj
85: WHERE ppc.project_id = p_project_id
86: AND ppc.class_category = pcc.class_category
87: AND assocs.classification_code = 'CLASS_CATEGORY:'||to_char(pcc.class_category_id)

Line 125: PA_CLASS_CATEGORIES pcc,

121: UNION
122: SELECT DISTINCT assocs.attr_group_id
123: FROM EGO_OBJ_AG_ASSOCS_B assocs,
124: PA_PROJECT_CLASSES ppc,
125: PA_CLASS_CATEGORIES pcc,
126: FND_OBJECTS obj
127: WHERE ppc.project_id = p_project_id
128: AND ppc.class_category = pcc.class_category
129: AND assocs.classification_code = 'CLASS_CATEGORY:'||to_char(pcc.class_category_id)