APPS.PA_HR_UPDATE_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 270: FROM per_assignment_status_types past

266: AND paaf.job_id is NOT NULL
267: AND paaf.primary_flag = 'Y'
268: AND paaf.assignment_type in ('E', 'C')
269: AND ((SELECT per_system_status
270: FROM per_assignment_status_types past
271: WHERE past.assignment_status_type_id = paaf.assignment_status_type_id) IN ('ACTIVE_ASSIGN','ACTIVE_CWK')); --Bug#8879958
272: END IF;
273:
274: IF l_job_id is NOT NULL THEN

Line 2207: , per_assignment_status_types pastype

2203: , hrinf.org_information1
2204: FROM per_all_assignments_f assn
2205: , hr_organization_information hrinf
2206: /* , per_person_types pertypes Commented for bug#2781713 */
2207: , per_assignment_status_types pastype
2208: , pa_resource_txn_attributes res
2209: , pa_all_organizations allorgs
2210: , per_all_people_f pep
2211: WHERE

Line 2258: , per_assignment_status_types pastype

2254: -- , hrinf.org_information1
2255: FROM per_all_assignments_f assn
2256: , hr_organization_information hrinf
2257: /* , per_person_types pertypes Commented for bug#2781713 */
2258: , per_assignment_status_types pastype
2259: , pa_resource_txn_attributes res
2260: , pa_all_organizations allorgs
2261: , per_all_people_f pep
2262: WHERE

Line 2416: , per_assignment_status_types pastype

2412: ,assn.effective_end_date
2413: FROM per_all_assignments_f assn
2414: , hr_organization_information hrinf
2415: /* , per_person_types pertypes Commented for Bug#2781713 */
2416: , per_assignment_status_types pastype
2417: , per_all_people_f pep
2418: WHERE
2419: assn.assignment_status_type_id = pastype.assignment_status_type_id
2420: AND assn.primary_flag = 'Y'

Line 2454: , per_assignment_status_types pastype

2450: ,assn.effective_end_date
2451: FROM per_all_assignments_f assn
2452: , hr_organization_information hrinf
2453: /* , per_person_types pertypes Commented for Bug#2781713 */
2454: , per_assignment_status_types pastype
2455: , per_all_people_f pep
2456: WHERE
2457: assn.assignment_status_type_id = pastype.assignment_status_type_id
2458: AND assn.primary_flag = 'Y'

Line 3371: per_assignment_status_types past

3367: /*
3368: SELECT MAX(paaf.effective_end_date)
3369: INTO l_resource_effective_end_date
3370: FROM per_all_assignments_f paaf,
3371: per_assignment_status_types past
3372: WHERE paaf.person_id=p_person_id
3373: AND paaf.primary_flag = 'Y'
3374: AND paaf.assignment_type in ('E','C')
3375: AND past.assignment_status_type_id = paaf.assignment_status_type_id