APPS.HR_APPLICANT_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1503: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;

1499: --
1500: l_exists varchar2(1);
1501: l_count number;
1502: l_multi_flag boolean;
1503: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;
1504: l_chk_person_id per_all_people_f.person_id%TYPE;
1505: --
1506: l_person_type_id number := p_person_type_id;
1507: l_person_type_id1 number;

Line 1520: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

1516: --
1517: l_hire_date date;
1518: l_original_date_of_hire date;
1519: --
1520: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1521: l_assignment_id per_assignments_f.assignment_id%TYPE;
1522: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1523: --
1524: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

Line 1631: per_assignment_status_types pas

1627: --
1628: cursor csr_chk_asg_status is
1629: select count(asg.assignment_id)
1630: from per_assignments_f asg,
1631: per_assignment_status_types pas
1632: where asg.assignment_status_type_id = pas.assignment_status_type_id
1633: and asg.person_id = p_person_id
1634: and pas.per_system_status = 'ACCEPTED'
1635: and l_hire_date between asg.effective_start_date

Line 1643: per_assignment_status_types pas

1639: select per.person_id,
1640: pas.per_system_status
1641: from per_all_people_f per,
1642: per_assignments_f asg,
1643: per_assignment_status_types pas
1644: where asg.assignment_status_type_id = pas.assignment_status_type_id
1645: and per.person_id = asg.person_id
1646: and l_hire_date between per.effective_start_date
1647: and per.effective_end_date

Line 1656: per_assignment_status_types pas

1652: cursor csr_get_un_accepted is
1653: select asg.assignment_id,
1654: asg.object_version_number
1655: from per_assignments_f asg,
1656: per_assignment_status_types pas
1657: where asg.assignment_status_type_id = pas.assignment_status_type_id
1658: and asg.person_id = p_person_id
1659: and l_hire_date between asg.effective_start_date
1660: and asg.effective_end_date

Line 1670: per_assignment_status_types pas

1666: select asg.assignment_id,
1667: asg.object_version_number,
1668: asg.vacancy_id
1669: from per_assignments_f asg,
1670: per_assignment_status_types pas
1671: where asg.assignment_status_type_id = pas.assignment_status_type_id
1672: and asg.person_id = p_person_id
1673: and l_hire_date between asg.effective_start_date
1674: and asg.effective_end_date

Line 1685: per_assignment_status_types pas

1681: select asg.assignment_id,
1682: asg.object_version_number,
1683: asg.vacancy_id
1684: from per_assignments_f asg,
1685: per_assignment_status_types pas
1686: where asg.assignment_status_type_id = pas.assignment_status_type_id
1687: and asg.person_id = p_person_id
1688: and l_hire_date between asg.effective_start_date
1689: and asg.effective_end_date

Line 1698: per_assignment_status_types pas

1694: select asg.assignment_id,
1695: asg.object_version_number,
1696: asg.vacancy_id
1697: from per_assignments_f asg,
1698: per_assignment_status_types pas
1699: where asg.assignment_status_type_id = pas.assignment_status_type_id
1700: and asg.person_id = p_person_id
1701: and l_hire_date between asg.effective_start_date
1702: and asg.effective_end_date