DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_PKG dependencies on PA_TASKS

Line 1436: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt

1432: where ci_id = p_ci_id;
1433:
1434: cursor get_assignment_details(p_bvId number, p_task_id number, p_res_id number) is
1435: select pra.RESOURCE_ASSIGNMENT_ID, ppe.ELEMENT_NUMBER, ppe.NAME
1436: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt
1437: WHERE pra.budget_version_id = p_bvId
1438: and pra.task_id = p_task_id
1439: and pra.RESOURCE_LIST_MEMBER_ID = p_res_id
1440: and pt.task_id = ppe.proj_element_id;