DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_PROGRESS_ROLLUP

Line 5956: /* Code to delete records from tables: pa_progress_rollup and pa_precent_completes. */

5952: -- commented below code , as it was getting called in loop
5953: -- Shifted this api out of for loop and passing the l_task_version_id_tbl plsql table to
5954: -- progres api
5955:
5956: /* Code to delete records from tables: pa_progress_rollup and pa_precent_completes. */
5957:
5958: /*
5959: BEGIN
5960:

Line 7224: from pa_progress_rollup ppru, pa_percent_completes ppc

7220: cur_proj_elem_ver_sch_rec cur_proj_elem_ver_sch%ROWTYPE;
7221:
7222: CURSOR get_actual_wq(c_project_id NUMBER, c_element_id NUMBER) IS
7223: select ppru.CUMULATIVE_WORK_QUANTITY
7224: from pa_progress_rollup ppru, pa_percent_completes ppc
7225: where ppc.project_id = c_project_id
7226: and ppc.task_id = c_element_id
7227: and ppc.current_flag = 'Y'
7228: and ppc.project_Id = ppru.project_id