DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on FND_PROFILE

Line 1509: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);

1505: */
1506:
1507: --8793163 For Dual Actions Benefits need to defaulted even if second action is conversion to appointment
1508: IF (l_family_code = 'CONV_APP' OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') OR l_family_code = 'EXT_NTE' THEN
1509: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
1510: -- Check if FEHB exists
1511: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Health Benefits',l_bus_group_id,l_effective_date,null);
1512: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1513: l_fehb_exists := TRUE;

Line 3732: l_resp_id := fnd_profile.value('RESP_ID');

3728: l_payment_option := c_noa_fam_code_rec.payment_option;
3729: END LOOP;
3730: hr_utility.set_location('l_noa_family_code '|| l_noa_family_code,10);
3731:
3732: l_resp_id := fnd_profile.value('RESP_ID');
3733: l_application_id := fnd_profile.value('RESP_APPL_ID');
3734: hr_utility.set_location('Resp id '|| l_resp_id,10);
3735: hr_utility.set_location('appl id '|| l_application_id,10);
3736: for c_info_type_rec in c_info_types(l_application_id,l_resp_id) loop

Line 3733: l_application_id := fnd_profile.value('RESP_APPL_ID');

3729: END LOOP;
3730: hr_utility.set_location('l_noa_family_code '|| l_noa_family_code,10);
3731:
3732: l_resp_id := fnd_profile.value('RESP_ID');
3733: l_application_id := fnd_profile.value('RESP_APPL_ID');
3734: hr_utility.set_location('Resp id '|| l_resp_id,10);
3735: hr_utility.set_location('appl id '|| l_application_id,10);
3736: for c_info_type_rec in c_info_types(l_application_id,l_resp_id) loop
3737: l_information_type := c_info_type_rec.information_type;

Line 4524: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_business_group_id);

4520: hr_utility.set_location('bus gp is ' || bus_gp.business_group_id,12);
4521: l_business_group_id := bus_gp.business_group_id;
4522: end loop;
4523: Else
4524: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_business_group_id);
4525: hr_utility.set_location('bus gp is ' || l_business_group_id,13);
4526: End if;
4527: for def_payroll in c_def_payroll loop
4528: hr_utility.set_location(l_proc,14);