APPS.PA_TRANSACTIONS_PUB dependencies on PA_PROJ_ELEMENTS

Line 1030: from pa_proj_elements ppe

1026: X_msg_count:=0;
1027:
1028: select count(*)
1029: into l_cm_subt_count
1030: from pa_proj_elements ppe
1031: where ppe.proj_element_id= X_task_id
1032: and ppe.project_id=X_project_id
1033: /*and link_task_flag='Y'*/ /*bug 8916805*/ /*commented for bug 8996313*/
1034: and exists (select por.* from /*modified logic for bug 8996313*/

Line 1037: pa_proj_elements ppe1,

1033: /*and link_task_flag='Y'*/ /*bug 8916805*/ /*commented for bug 8996313*/
1034: and exists (select por.* from /*modified logic for bug 8996313*/
1035: pa_proj_element_versions ppev,
1036: pa_proj_element_versions ppev1,
1037: pa_proj_elements ppe1,
1038: pa_object_relationships por
1039: where
1040: ppev.element_version_id = por.object_id_from1
1041: and ppev.proj_element_id =ppe.proj_element_id