APPS.PA_FP_COPY_FROM_PKG dependencies on PA_TASKS

Line 3707: AND object_type = 'PA_TASKS'

3703: (SELECT TO_NUMBER(attribute15) source_task_id,
3704: proj_element_id target_task_id
3705: FROM pa_proj_elements
3706: WHERE project_id = l_target_project_id
3707: AND object_type = 'PA_TASKS'
3708: UNION ALL
3709: SELECT 0 source_task_id,
3710: 0 target_task_id
3711: FROM dual) pelm,

Line 3980: AND object_type='PA_TASKS'

3976: (SELECT TO_NUMBER(attribute15) source_task_id,
3977: proj_element_id target_task_id
3978: FROM pa_proj_elements
3979: WHERE project_id = l_target_project_id
3980: AND object_type='PA_TASKS'
3981: UNION ALL
3982: SELECT 0 source_task_id,
3983: 0 target_task_id
3984: FROM dual) pelm

Line 7445: FROM pa_tasks t

7441: END IF;
7442:
7443: SELECt min(t.start_date)
7444: INTO l_start_date
7445: FROM pa_tasks t
7446: WHERE t.project_id = p_source_project_id;
7447:
7448: IF l_start_date is NULL THEN
7449:

Line 8786: AND tpe.object_type='PA_TASKS'

8782: ,pa_proj_elements tpe
8783: WHERE spe.project_id=p_source_project_id
8784: AND tpe.project_id=p_target_project_id
8785: AND spe.element_number=tpe.element_number
8786: AND tpe.object_type='PA_TASKS'
8787: AND spe.object_type='PA_TASKS'
8788: AND telv.proj_element_id = tpe.proj_element_id
8789: AND selv.proj_element_id =spe.proj_element_id
8790: AND selv.parent_structure_version_id=c_src_struct_ver_id

Line 8787: AND spe.object_type='PA_TASKS'

8783: WHERE spe.project_id=p_source_project_id
8784: AND tpe.project_id=p_target_project_id
8785: AND spe.element_number=tpe.element_number
8786: AND tpe.object_type='PA_TASKS'
8787: AND spe.object_type='PA_TASKS'
8788: AND telv.proj_element_id = tpe.proj_element_id
8789: AND selv.proj_element_id =spe.proj_element_id
8790: AND selv.parent_structure_version_id=c_src_struct_ver_id
8791: AND telv.parent_structure_version_id=c_targ_struct_ver_id