APPS.PSP_CREATE_EFF_REPORTS dependencies on FND_PROFILE

Line 243: l_profile_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

239:
240: ---select count(*) into l_gt_count from psp_supercede_persons_gt ;
241: ---hr_utility.trace(' COUNT of supercede persons_gt ='|| l_gt_Count);
242:
243: l_profile_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
244: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
245: l_bg_currency_code := psp_general.get_currency_code(l_profile_bg_id);
246:
247:

Line 244: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

240: ---select count(*) into l_gt_count from psp_supercede_persons_gt ;
241: ---hr_utility.trace(' COUNT of supercede persons_gt ='|| l_gt_Count);
242:
243: l_profile_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
244: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
245: l_bg_currency_code := psp_general.get_currency_code(l_profile_bg_id);
246:
247:
248: --OPEN HUNDRED_PCENT_EFF_CSR(p_request_id); Commented for UVA bug fix 4537063

Line 1606: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

1602: AND perd.project_id IS NULL
1603: AND ROWNUM = 1;
1604: BEGIN
1605:
1606: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: OPEN layout_type_cur;
1610: FETCH layout_type_cur INTO l_layout_type;