APPS.GHR_MASS_CON_PROGRAM dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1910: SELECT user_status from per_assignment_status_types

1906: -- Check assignment_status_type
1907: --
1908:
1909: CURSOR cur_472_ast (asg_status_type_id number) IS
1910: SELECT user_status from per_assignment_status_types
1911: WHERE assignment_status_type_id = asg_status_type_id
1912: AND upper(user_status) not in (
1913: 'TERMINATE ASSIGNMENT', /* 3 */
1914: 'ACTIVE APPLICATION', /* 4 */

Line 1943: per_assignment_status_types past

1939: FROM per_assignments_f paf,
1940: per_people_f ppf,
1941: per_person_types ppt,
1942: hr_organization_units hou,
1943: per_assignment_status_types past
1944: WHERE ppf.person_id = paf.person_id
1945: AND l_eff_date between ppf.effective_start_date and ppf.effective_end_date
1946: AND l_eff_date between paf.effective_start_date and paf.effective_end_date
1947: AND paf.primary_flag = 'Y'