DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PUB dependencies on PA_TASKS

Line 559: select count(pt.task_id) from pa_tasks pt where project_id=p_project_id and task_manager_person_id =

555: l_msg_index_out NUMBER;
556: l_task_cnt NUMBER := 0;
557: --Changes for 8726175
558: cursor task_cnt_crsr is
559: select count(pt.task_id) from pa_tasks pt where project_id=p_project_id and task_manager_person_id =
560: (select resource_source_id from pa_project_parties where project_party_id=p_project_party_id
561: and project_id=p_project_id)
562: and exists
563: (select 1 from pa_progress_rollup where project_id=pt.project_id and proj_element_id = pt.task_id