APPS.PA_TASK_APPROVAL_PKG dependencies on PA_OBJECT_RELATIONSHIPS

Line 30: FROM PA_OBJECT_RELATIONSHIPS

26: WHERE proj_element_id = p_proj_element
27: AND parent_structure_version_id = p_parent_struc_ver
28: AND financial_task_flag = 'Y'
29: AND EXISTS (SELECT 1
30: FROM PA_OBJECT_RELATIONSHIPS
31: WHERE object_type_from = 'PA_TASKS'
32: AND object_id_to1 = element_version_id
33: AND object_type_to = 'PA_TASKS'
34: AND relationship_type = 'S');

Line 91: FROM PA_OBJECT_RELATIONSHIPS

87: WHERE proj_element_id = p_parent_task_id
88: AND parent_structure_version_id = p_parent_struc_ver
89: AND financial_task_flag = 'Y'
90: AND EXISTS (SELECT 1
91: FROM PA_OBJECT_RELATIONSHIPS
92: WHERE object_type_from = 'PA_STRUCTURES'
93: AND object_id_to1 = element_version_id
94: AND object_type_to = 'PA_TASKS'
95: AND relationship_type = 'S');

Line 196: pa_object_relationships por

192: select budget_version_id from pa_budget_versions where ci_id = p_ci_id )
193: and exists (select 1
194: from pa_proj_elements ppe,
195: pa_proj_element_versions ppev,
196: pa_object_relationships por
197: where ppe.proj_element_id = pra.task_id
198: and ppe.project_id = pra.project_id
199: and ppe.link_task_flag = 'Y'
200: and ppe.type_id = 1