APPS.PA_USER_ATTR_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 41: FROM EGO_OBJ_AG_ASSOCS_B assocs,

37:
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'

Line 48: FROM EGO_OBJ_AG_ASSOCS_B assocs,

44: AND assocs.object_id = obj.object_id
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';

Line 57: FROM EGO_OBJ_AG_ASSOCS_B assocs,

53:
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';

Line 69: FROM EGO_OBJ_AG_ASSOCS_B assocs,

65: SELECT 'Y'
66: FROM DUAL
67: WHERE c_attr_group_id IN
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

Line 81: FROM EGO_OBJ_AG_ASSOCS_B assocs,

77: AND assocs.object_id = obj.object_id
78: AND obj.obj_name = 'PA_PROJECTS'
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

Line 93: FROM EGO_OBJ_AG_ASSOCS_B assocs,

89: AND assocs.object_id = obj.object_id
90: AND obj.obj_name = 'PA_PROJECTS'
91: UNION
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

Line 111: FROM EGO_OBJ_AG_ASSOCS_B assocs,

107: SELECT 'Y'
108: FROM DUAL
109: WHERE c_attr_group_id IN
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

Line 123: FROM EGO_OBJ_AG_ASSOCS_B assocs,

119: AND assocs.object_id = obj.object_id
120: AND obj.obj_name = 'PA_PROJECTS'
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

Line 135: FROM EGO_OBJ_AG_ASSOCS_B assocs,

131: AND assocs.object_id = obj.object_id
132: AND obj.obj_name = 'PA_PROJECTS'
133: UNION
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

Line 148: FROM EGO_OBJ_AG_ASSOCS_B assocs,

144: AND assocs.object_id = obj.object_id
145: AND obj.obj_name = 'PA_PROJECTS'
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