APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PA_PROJ_ELEMENTS

Line 126: FROM pa_proj_elements

122: /* Program Changes - Get the project id based on the wbs element id */
123:
124: SELECT project_id
125: INTO x_prg_project_id
126: FROM pa_proj_elements
127: WHERE proj_element_id = p_wbs_element_id ;
128:
129:
130: /* The following SQL will get the reporting period which is based on the calandar type and Time Id */

Line 313: FROM pa_proj_elements

309:
310: BEGIN
311: SELECT object_type
312: INTO l_object_type
313: FROM pa_proj_elements
314: WHERE proj_element_id = p_wbs_element_id;
315: EXCEPTION WHEN OTHERS THEN
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
317: x_msg_count := x_msg_count + 1;

Line 527: FROM pa_proj_elements

523:
524: BEGIN
525: SELECT object_type
526: INTO l_object_type
527: FROM pa_proj_elements
528: WHERE proj_element_id = p_wbs_element_id;
529: EXCEPTION WHEN OTHERS THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_msg_count := x_msg_count + 1;