DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1712: from pa_resource_assignments ra , pa_project_assignments pa

1708: RETURN VARCHAR2 IS
1709:
1710: Cursor C_At_Risk_Start IS
1711: select ra.schedule_start_date, pa.start_date, pa.end_date
1712: from pa_resource_assignments ra , pa_project_assignments pa
1713: where pa.assignment_id = ra.project_assignment_id
1714: and ra.project_id = p_project_id
1715: and ra.budget_version_id = p_budget_version_id
1716: and ra.resource_list_member_id = p_resource_list_member_id;

Line 1721: from pa_resource_assignments ra , pa_project_assignments pa

1717: C_At_Risk_Start_Rec C_At_Risk_Start%ROWTYPE;
1718:
1719: Cursor C_At_Risk_End IS
1720: select ra.schedule_end_date, pa.end_date, pa.start_date
1721: from pa_resource_assignments ra , pa_project_assignments pa
1722: where pa.assignment_id = ra.project_assignment_id
1723: and ra.project_id = p_project_id
1724: and ra.budget_version_id = p_budget_version_id
1725: and ra.resource_list_member_id = p_resource_list_member_id;