APPS.PA_DELIVERABLE_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE

1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
1534: ,p_project_id IN pa_projects_all.project_id%TYPE
1535: ,p_calling_context IN VARCHAR2 := 'TASKS'
1536: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE

1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
1534: ,p_project_id IN pa_projects_all.project_id%TYPE
1535: ,p_calling_context IN VARCHAR2 := 'TASKS'
1536: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1537: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2681: ,pa_object_relationships obj

2677: ,ppe.name
2678: FROM pa_proj_elements ppe
2679: ,pa_proj_element_versions pev1
2680: ,pa_proj_element_versions pev2
2681: ,pa_object_relationships obj
2682: WHERE pev2.element_version_id = c_task_version_id
2683: AND obj.object_id_from2 = pev2.proj_element_id
2684: AND obj.object_type_from = 'PA_TASKS'
2685: AND obj.object_type_to = 'PA_DELIVERABLES'