APPS.PA_USER_ATTR_PUB dependencies on PA_PROJ_ELEMENTS

Line 36: FROM PA_PROJ_ELEMENTS

32:
33: CURSOR get_project_id(c_task_id NUMBER)
34: IS
35: SELECT project_id
36: FROM PA_PROJ_ELEMENTS
37: WHERE proj_element_id = c_task_id;
38:
39: CURSOR get_proj_elements(c_project_id NUMBER)
40: IS

Line 42: FROM PA_PROJ_ELEMENTS

38:
39: CURSOR get_proj_elements(c_project_id NUMBER)
40: IS
41: SELECT proj_element_id
42: FROM PA_PROJ_ELEMENTS
43: WHERE project_id = c_project_id;
44:
45: CURSOR get_new_proj_element_id(c_old_proj_element_id NUMBER, c_old_project_id NUMBER, c_new_project_id NUMBER)
46: IS

Line 48: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENTS ppe2

44:
45: CURSOR get_new_proj_element_id(c_old_proj_element_id NUMBER, c_old_project_id NUMBER, c_new_project_id NUMBER)
46: IS
47: SELECT ppe2.proj_element_id
48: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENTS ppe2
49: WHERE ppe.project_id = c_old_project_id
50: AND ppe.proj_element_id = c_old_proj_element_id
51: AND ppe.element_number = ppe2.element_number
52: AND ppe2.project_id = c_new_project_id;