DBA Data[Home] [Help]

APPS.PER_VAC_BUS dependencies on FND_PROFILE

Line 1739: and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));

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

Line 1955: and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));

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'));
1956: --
1957: cursor csr_manager2 is
1958: select null
1959: from per_all_people_f