eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_WHATIF_ELIG dependencies on PER_COMPETENCE_ELEMENTS

Line 3536: select * from per_competence_elements cel

3532: ,p_effective_date in date
3533: ) is
3534:
3535: cursor c_comp_rec is
3536: select * from per_competence_elements cel
3537: where cel.person_id = p_person_id
3538: and cel.competence_id = p_competence_id
3539: and cel.business_group_id = p_business_group_id
3540: and p_effective_date between cel.effective_date_from and nvl(cel.effective_date_to, p_effective_date);

Line 3544: per_comp_elmnt_rec per_competence_elements%rowtype;

3540: and p_effective_date between cel.effective_date_from and nvl(cel.effective_date_to, p_effective_date);
3541:
3542: l_comp_elmnt_id number;
3543: l_object_version_number number;
3544: per_comp_elmnt_rec per_competence_elements%rowtype;
3545: l_comp_rec c_comp_rec%rowtype;
3546: begin
3547: if p_person_id is not null then
3548: per_comp_elmnt_rec.person_id := p_person_id;