DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_PERCENT_COMPLETES

Line 7827: from pa_progress_rollup ppru, pa_percent_completes ppc

7823: cur_proj_elem_ver_sch_rec cur_proj_elem_ver_sch%ROWTYPE;
7824:
7825: CURSOR get_actual_wq(c_project_id NUMBER, c_element_id NUMBER) IS
7826: select ppru.CUMULATIVE_WORK_QUANTITY
7827: from pa_progress_rollup ppru, pa_percent_completes ppc
7828: where ppc.project_id = c_project_id
7829: and ppc.task_id = c_element_id
7830: and ppc.current_flag = 'Y'
7831: and ppc.project_Id = ppru.project_id