APPS.PAY_IN_UTILS dependencies on FND_PROFILE

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

1183: CURSOR csr_element_type_id
1184: IS
1185: SELECT element_type_id
1186: FROM pay_element_types_f
1187: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
1188: AND element_name = p_element_name
1189: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1190:
1191: /*

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

2324: IS
2325: SELECT 1
2326: FROM per_assignments_f
2327: WHERE assignment_id = p_assignment_id
2328: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2329: ORDER BY effective_end_date DESC;
2330:
2331: l_bg_flag NUMBER := -1;
2332: l_procedure CONSTANT VARCHAR2(100):= g_package ||'chk_business_group';

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

2419: FROM pay_element_types_f pee
2420: ,pay_element_templates pet
2421: ,pay_shadow_element_types pset
2422: WHERE pee.element_type_id = p_element_type_id
2423: AND pee.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2424: AND pee.element_name = pset.element_name
2425: AND pset.template_id = pet.template_id
2426: AND p_date_earned BETWEEN pee.effective_start_date AND pee.effective_end_date;
2427: