APPS.PER_DB_PER_ADDITIONAL dependencies on FND_PROFILE

Line 1137: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')

1133: SELECT person_id
1134: INTO l_recruiter_id
1135: FROM per_people_f
1136: WHERE (business_group_id = l_business_group_id or
1137: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
1138: AND person_id = p_recruiter_id
1139: AND current_employee_flag = 'Y'
1140: AND l_effective_start_date BETWEEN effective_start_date
1141: AND effective_end_date;

Line 1151: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')

1147: SELECT person_id
1148: INTO l_person_referred_by_id
1149: FROM per_people_f
1150: WHERE (business_group_id = l_business_group_id or
1151: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
1152: AND person_id = p_person_referred_by_id
1153: AND current_employee_flag = 'Y'
1154: AND l_effective_start_date BETWEEN effective_start_date
1155: AND effective_end_date;

Line 1489: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

1485: SELECT person_id
1486: INTO l_supervisor_id
1487: FROM per_people_f
1488: WHERE (business_group_id = l_business_group_id OR
1489: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1490: AND person_id = p_supervisor_id
1491: AND current_employee_flag = 'Y'
1492: AND l_effective_start_date BETWEEN effective_start_date
1493: AND effective_end_date;

Line 2089: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')

2085: SELECT person_id
2086: INTO l_recruiter_id
2087: FROM per_people_f
2088: WHERE (business_group_id = l_business_group_id or
2089: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
2090: AND person_id = p_recruiter_id
2091: AND current_employee_flag = 'Y'
2092: AND l_effective_start_date BETWEEN effective_start_date
2093: AND effective_end_date;

Line 2103: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')

2099: SELECT person_id
2100: INTO l_person_referred_by_id
2101: FROM per_people_f
2102: WHERE (business_group_id = l_business_group_id or
2103: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
2104: AND person_id = p_person_referred_by_id
2105: AND current_employee_flag = 'Y'
2106: AND l_effective_start_date BETWEEN effective_start_date
2107: AND effective_end_date;