APPS.PA_WORKPLAN_ATTR_UTILS dependencies on PA_LIFECYCLE_USAGES

Line 33: pa_lifecycle_usages plu

29: if (p_lifecycle_name is not NULL) then
30: SELECT pev.element_version_id
31: INTO x_lifecycle_id
32: FROM pa_proj_elements pe, pa_proj_element_versions pev,
33: pa_lifecycle_usages plu
34: WHERE pe.project_id=0
35: AND pe.proj_element_id = pev.proj_element_id
36: AND pe.element_number = p_lifecycle_name
37: AND pe.proj_element_id = plu.LIFECYCLE_ID

Line 54: pa_lifecycle_usages plu

50: ELSE
51: SELECT pev.element_version_id
52: INTO x_lifecycle_id
53: FROM pa_proj_elements pe, pa_proj_element_versions pev,
54: pa_lifecycle_usages plu
55: WHERE pe.project_id=0
56: AND pe.proj_element_id = pev.proj_element_id
57: AND pe.element_number = p_lifecycle_name
58: AND pe.proj_element_id = plu.LIFECYCLE_ID