DBA Data[Home] [Help]

APPS.PQH_PSF_BUS dependencies on FND_PROFILE

Line 4222: l_business_group_id := NVL(hr_general.get_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID'));

4218: AND NVL(pos.position_control_structure_flg,'N') = 'Y'
4219: AND pos.business_group_id = p_business_group_id;
4220: begin
4221: if p_business_group_id is null then
4222: l_business_group_id := NVL(hr_general.get_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID'));
4223: else
4224: l_business_group_id := p_business_group_id;
4225: end if;
4226: if p_effective_date is null then