APPS.PAY_IN_UTILS dependencies on FND_PROFILE

Line 1172: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

1168: CURSOR csr_element_type_id
1169: IS
1170: SELECT element_type_id
1171: FROM pay_element_types_f
1172: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
1173: AND element_name = p_element_name
1174: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1175:
1176: /*

Line 2313: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2309: IS
2310: SELECT 1
2311: FROM per_assignments_f
2312: WHERE assignment_id = p_assignment_id
2313: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2314: ORDER BY effective_end_date DESC;
2315:
2316: l_bg_flag NUMBER := -1;
2317: l_procedure CONSTANT VARCHAR2(100):= g_package ||'chk_business_group';

Line 2408: AND pee.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2404: FROM pay_element_types_f pee
2405: ,pay_element_templates pet
2406: ,pay_shadow_element_types pset
2407: WHERE pee.element_type_id = p_element_type_id
2408: AND pee.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2409: AND pee.element_name = pset.element_name
2410: AND pset.template_id = pet.template_id
2411: AND p_date_earned BETWEEN pee.effective_start_date AND pee.effective_end_date;
2412: