APPS.PA_COST1 dependencies on PA_PROJ_ELEMENTS

Line 1327: -- bug 12557318: changed the cursor to get the task_number from pa_proj_elements

1323: print_msg(l_debug_flag,l_stage);
1324:
1325: if p_task_id is not null then
1326: -- get the task number details
1327: -- bug 12557318: changed the cursor to get the task_number from pa_proj_elements
1328: -- and not pa_tasks. Non-shared workplan tasks do not exist in pa_tasks.
1329: begin
1330: select element_number
1331: into pa_pay_util.g_task_number

Line 1332: from pa_proj_elements

1328: -- and not pa_tasks. Non-shared workplan tasks do not exist in pa_tasks.
1329: begin
1330: select element_number
1331: into pa_pay_util.g_task_number
1332: from pa_proj_elements
1333: where proj_element_id = p_task_id
1334: and project_id = p_project_id;
1335:
1336: l_stage := 'RBC: Task Number from elements: ' || pa_pay_util.g_task_number;