DBA Data[Home] [Help]

APPS.PQP_VEH_MULTI_ALLOC dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 360: assignment_status_type_id from PER_ASSIGNMENT_STATUS_TYPES past

356: and pva.business_group_id=paa.business_group_id)
357: -- Added where condition to prevent vehicle allocation to
358: -- assignments other than ACTIVE_ASSIGN and ACTIVE_CWK Bug#12340048
359: AND paa.assignment_status_type_id IN (select
360: assignment_status_type_id from PER_ASSIGNMENT_STATUS_TYPES past
361: where past.per_system_status IN ('ACTIVE_ASSIGN', 'ACTIVE_CWK'))
362: AND p_effective_date BETWEEN paa.effective_start_date
363: AND paa.effective_end_date;
364: l_get_asg c_get_asg%ROWTYPE;