1731: l_api_updating boolean;
1732: --
1733: cursor csr_recruiter1 is
1734: select null
1735: from per_all_people_f
1736: where person_id = p_recruiter_id
1737: and (p_business_group_id = business_group_id
1738: or (p_business_group_id <> business_group_id
1739: and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));
1740:
1741: --
1742: cursor csr_recruiter2 is
1743: select null
1744: from per_all_people_f
1745: where person_id = p_recruiter_id
1746: and p_effective_date between effective_start_date and effective_end_date;
1747: --
1748: Begin
1947: l_api_updating boolean;
1948: --
1949: cursor csr_manager1 is
1950: select null
1951: from per_all_people_f
1952: where person_id = p_manager_id
1953: and(p_business_group_id = business_group_id
1954: or (p_business_group_id <> business_group_id
1955: and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));
1955: and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));
1956: --
1957: cursor csr_manager2 is
1958: select null
1959: from per_all_people_f
1960: where person_id = p_manager_id
1961: and p_effective_date between effective_start_date and effective_end_date;
1962: --
1963: Begin
2047: l_api_updating boolean;
2048: --
2049: cursor csr_manager is
2050: select null
2051: from per_all_assignments_f paf,per_all_people_f ppf
2052: where paf.vacancy_id = p_vacancy_id
2053: and ppf.person_id = paf.person_id
2054: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
2055: and ppf.party_id = (select ppf.party_id
2052: where paf.vacancy_id = p_vacancy_id
2053: and ppf.person_id = paf.person_id
2054: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
2055: and ppf.party_id = (select ppf.party_id
2056: from per_all_people_f ppf
2057: where ppf.person_id = p_manager_id
2058: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date);
2059: --
2060: Begin