APPS.PA_FP_COPY_FROM_PKG dependencies on PA_TASKS

Line 3717: AND object_type = 'PA_TASKS'

3713: (SELECT TO_NUMBER(attribute15) source_task_id,
3714: proj_element_id target_task_id
3715: FROM pa_proj_elements
3716: WHERE project_id = l_target_project_id
3717: AND object_type = 'PA_TASKS'
3718: UNION ALL
3719: SELECT 0 source_task_id,
3720: 0 target_task_id
3721: FROM dual) pelm,

Line 3992: AND object_type='PA_TASKS'

3988: (SELECT TO_NUMBER(attribute15) source_task_id,
3989: proj_element_id target_task_id
3990: FROM pa_proj_elements
3991: WHERE project_id = l_target_project_id
3992: AND object_type='PA_TASKS'
3993: UNION ALL
3994: SELECT 0 source_task_id,
3995: 0 target_task_id
3996: FROM dual) pelm

Line 7464: FROM pa_tasks t

7460: END IF;
7461:
7462: SELECt min(t.start_date)
7463: INTO l_start_date
7464: FROM pa_tasks t
7465: WHERE t.project_id = p_source_project_id;
7466:
7467: IF l_start_date is NULL THEN
7468:

Line 8813: AND tpe.object_type='PA_TASKS'

8809: ,pa_proj_elements tpe
8810: WHERE spe.project_id=p_source_project_id
8811: AND tpe.project_id=p_target_project_id
8812: AND spe.element_number=tpe.element_number
8813: AND tpe.object_type='PA_TASKS'
8814: AND spe.object_type='PA_TASKS'
8815: AND telv.proj_element_id = tpe.proj_element_id
8816: AND selv.proj_element_id =spe.proj_element_id
8817: AND selv.parent_structure_version_id=c_src_struct_ver_id

Line 8814: AND spe.object_type='PA_TASKS'

8810: WHERE spe.project_id=p_source_project_id
8811: AND tpe.project_id=p_target_project_id
8812: AND spe.element_number=tpe.element_number
8813: AND tpe.object_type='PA_TASKS'
8814: AND spe.object_type='PA_TASKS'
8815: AND telv.proj_element_id = tpe.proj_element_id
8816: AND selv.proj_element_id =spe.proj_element_id
8817: AND selv.parent_structure_version_id=c_src_struct_ver_id
8818: AND telv.parent_structure_version_id=c_targ_struct_ver_id