DBA Data[Home] [Help]

APPS.PA_RESOURCE_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 100: from pa_project_assignments

96: BEGIN
97: IF l_start_date is not null THEN
98: select min(start_date)
99: into l_end_date
100: from pa_project_assignments
101: where resource_id = p_resource_id
102: and start_date > l_start_date
103: and status_code in (select project_status_code
104: from pa_project_statuses