APPS.PER_QH_MAINTAIN_QUERY dependencies on HR_GENERAL

Line 451: ,SUBSTR(hr_general.decode_lookup('RATE_BASIS',pr.rate_basis),1,80) rate_basis

447: ,p_effective_date date) is
448: select gr.grade_rule_id
449: ,pr.name rate_name
450: ,gr.rate_id
451: ,SUBSTR(hr_general.decode_lookup('RATE_BASIS',pr.rate_basis),1,80) rate_basis
452: ,fnd_asr.meaning asg_rate_type_name
453: ,gr.currency_code
454: ,f.name rate_currency
455: ,gr.value

Line 1853: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);

1849: hr_utility.set_location(l_proc,785);
1850: --
1851: if asg_rec.location_id is not null then
1852: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);
1853: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1854: end if;
1855: out_rec.location_id :=asg_rec.location_id;
1856: --
1857: hr_utility.set_location(l_proc,790);