DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 550: SELECT * FROM pa_project_assignments

546:
547: /* Added for Bug 6631033 */
548: CURSOR l_staff_assn_exists_csr
549: IS
550: SELECT * FROM pa_project_assignments
551: WHERE project_id = p_project_id
552: AND ASSIGNMENT_TYPE = 'STAFFED_ASSIGNMENT'
553: AND PROJECT_ROLE_ID = 1
554: AND start_date = p_start_date_active