APPS.PA_USER_ATTR_PVT dependencies on FND_OBJECTS

Line 42: FND_OBJECTS obj

38: CURSOR get_deleted_attr_grps1
39: IS
40: SELECT assocs.attr_group_id, assocs.data_level
41: FROM EGO_OBJ_AG_ASSOCS_B assocs,
42: FND_OBJECTS obj
43: WHERE assocs.classification_code = p_classification_type||':'||to_char(p_old_classification_id)
44: AND assocs.object_id = obj.object_id
45: AND obj.obj_name = 'PA_PROJECTS'
46: MINUS

Line 49: FND_OBJECTS obj

45: AND obj.obj_name = 'PA_PROJECTS'
46: MINUS
47: SELECT assocs.attr_group_id, assocs.data_level
48: FROM EGO_OBJ_AG_ASSOCS_B assocs,
49: FND_OBJECTS obj
50: WHERE assocs.classification_code = p_classification_type||':'||to_char(p_new_classification_id)
51: AND assocs.object_id = obj.object_id
52: AND obj.obj_name = 'PA_PROJECTS';
53:

Line 58: FND_OBJECTS obj

54: CURSOR get_deleted_attr_grps2
55: IS
56: SELECT assocs.attr_group_id, assocs.data_level
57: FROM EGO_OBJ_AG_ASSOCS_B assocs,
58: FND_OBJECTS obj
59: WHERE assocs.classification_code = p_classification_type||':'||to_char(p_old_classification_id)
60: AND assocs.object_id = obj.object_id
61: AND obj.obj_name = 'PA_PROJECTS';
62:

Line 72: FND_OBJECTS obj

68: (SELECT assocs.attr_group_id
69: FROM EGO_OBJ_AG_ASSOCS_B assocs,
70: PA_PROJECTS_ALL ppa,
71: PA_PROJECT_TYPES ppt,
72: FND_OBJECTS obj
73: WHERE ppa.project_id = p_project_id
74: AND ppa.project_type = ppt.project_type
75: AND assocs.classification_code = 'PROJECT_TYPE:'||to_char(ppt.project_type_id)
76: AND assocs.data_level = 'PROJECT_LEVEL'

Line 84: FND_OBJECTS obj

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)
88: AND assocs.data_level = 'PROJECT_LEVEL'

Line 96: FND_OBJECTS obj

92: SELECT assocs.attr_group_id
93: FROM EGO_OBJ_AG_ASSOCS_B assocs,
94: PA_PROJECT_CLASSES ppc,
95: PA_CLASS_CODES pcc,
96: FND_OBJECTS obj
97: WHERE ppc.project_id = p_project_id
98: AND ppc.class_category = pcc.class_category
99: AND ppc.class_code = pcc.class_code
100: AND assocs.classification_code = 'CLASS_CODE:'||to_char(pcc.class_code_id)

Line 114: FND_OBJECTS obj

110: (SELECT assocs.attr_group_id
111: FROM EGO_OBJ_AG_ASSOCS_B assocs,
112: PA_PROJECTS_ALL ppa,
113: PA_PROJECT_TYPES ppt,
114: FND_OBJECTS obj
115: WHERE ppa.project_id = p_project_id
116: AND ppa.project_type = ppt.project_type
117: AND assocs.classification_code = 'PROJECT_TYPE:'||to_char(ppt.project_type_id)
118: AND assocs.data_level = 'TASK_LEVEL'

Line 126: FND_OBJECTS obj

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)
130: AND assocs.data_level = 'TASK_LEVEL'

Line 138: FND_OBJECTS obj

134: SELECT assocs.attr_group_id
135: FROM EGO_OBJ_AG_ASSOCS_B assocs,
136: PA_PROJECT_CLASSES ppc,
137: PA_CLASS_CODES pcc,
138: FND_OBJECTS obj
139: WHERE ppc.project_id = p_project_id
140: AND ppc.class_category = pcc.class_category
141: AND ppc.class_code = pcc.class_code
142: AND assocs.classification_code = 'CLASS_CODE:'||to_char(pcc.class_code_id)

Line 150: FND_OBJECTS obj

146: UNION
147: SELECT assocs.attr_group_id
148: FROM EGO_OBJ_AG_ASSOCS_B assocs,
149: PA_PROJ_ELEMENTS ppe,
150: FND_OBJECTS obj
151: WHERE ppe.project_id = p_project_id
152: AND ppe.proj_element_id = c_proj_element_id
153: AND assocs.classification_code = 'TASK_TYPE:'||to_char(ppe.type_id)
154: AND assocs.object_id = obj.object_id