DBA Data[Home] [Help]

APPS.PA_USER_ATTR_PVT dependencies on PA_PROJ_ELEMENTS

Line 149: PA_PROJ_ELEMENTS ppe,

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
153: AND assocs.classification_code = 'TASK_TYPE:'||to_char(ppe.type_id)

Line 160: FROM PA_PROJ_ELEMENTS

156:
157: CURSOR get_proj_elements
158: IS
159: SELECT proj_element_id
160: FROM PA_PROJ_ELEMENTS
161: WHERE project_id = p_project_id;
162:
163: BEGIN
164: if (p_debug_mode = 'Y') then