DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on HR_GENERAL

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

417: ,p_effective_date date) is
418: select gr.grade_rule_id
419: ,pr.name rate_name
420: ,gr.rate_id
421: ,SUBSTR(hr_general.decode_lookup('RATE_BASIS',pr.rate_basis),1,80) rate_basis
422: ,fnd_asr.meaning asg_rate_type_name
423: ,gr.currency_code
424: ,f.name rate_currency
425: ,gr.value

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

1815: hr_utility.set_location(l_proc,785);
1816: --
1817: if asg_rec.location_id is not null then
1818: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);
1819: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1820: end if;
1821: out_rec.location_id :=asg_rec.location_id;
1822: --
1823: hr_utility.set_location(l_proc,790);