APPS.PQH_RBC_STAGE_TO_RBC dependencies on HR_GENERAL

Line 253: where trunc(effective_end_date) = hr_general.end_of_time

249: begin
250: select pl_typ_id,name,effective_start_date
251: into l_pt_id,l_pt_name,l_effective_start_date
252: from ben_pl_typ_f
253: where trunc(effective_end_date) = hr_general.end_of_time
254: and business_group_id = p_business_group_id
255: and opt_typ_cd ='RBC';
256:
257: hr_utility.set_location('pl_typ name '||substr(l_pt_name,1,40),10);

Line 1112: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');

1108: p_key_column_value => l_plan_id,
1109: p_effective_date => p_effective_date);
1110: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1111: if l_db_ovn <> l_ovn then
1112: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');
1113: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1114: fnd_message.set_token('OBJECT ',l_object);
1115: fnd_message.set_token('OBJECT_NAME ',plan_rec.information170);
1116: fnd_message.raise_error;