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.

[Home] [Help]

APPS.HR_COMP_PROFILE_SS dependencies on HR_GENERAL

Line 23: ,hr_general.decode_lookup ('CERTIFICATION_METHOD' ,cmpe.certification_method) certification_method_desc

19: ,cmpe.effective_date_from
20: ,cmpe.effective_date_to
21: ,cmpe.certification_date
22: ,cmpe.certification_method
23: ,hr_general.decode_lookup ('CERTIFICATION_METHOD' ,cmpe.certification_method) certification_method_desc
24: ,cmpe.next_certification_date
25: ,cmpe.source_of_proficiency_level
26: ,hr_general.decode_lookup ('PROFICIENCY_SOURCE' ,cmpe.source_of_proficiency_level) src_proficiency_lvl_desc
27: ,cmpe.comments

Line 26: ,hr_general.decode_lookup ('PROFICIENCY_SOURCE' ,cmpe.source_of_proficiency_level) src_proficiency_lvl_desc

22: ,cmpe.certification_method
23: ,hr_general.decode_lookup ('CERTIFICATION_METHOD' ,cmpe.certification_method) certification_method_desc
24: ,cmpe.next_certification_date
25: ,cmpe.source_of_proficiency_level
26: ,hr_general.decode_lookup ('PROFICIENCY_SOURCE' ,cmpe.source_of_proficiency_level) src_proficiency_lvl_desc
27: ,cmpe.comments
28: ,cvl.competence_alias
29: ,cmpe.status -- added for Competnce Qualification link enahncement
30: from per_rating_levels ratl

Line 3830: l_return := hr_general.decode_lookup('YES_NO', 'N');

3826: End If;
3827: Open prof_rec;
3828: Fetch prof_rec Into l_rec;
3829: If prof_rec%NOTFOUND Then
3830: l_return := hr_general.decode_lookup('YES_NO', 'N');
3831: Else
3832: l_return := hr_general.decode_lookup('YES_NO', 'Y');
3833: End If;
3834: Close prof_rec;

Line 3832: l_return := hr_general.decode_lookup('YES_NO', 'Y');

3828: Fetch prof_rec Into l_rec;
3829: If prof_rec%NOTFOUND Then
3830: l_return := hr_general.decode_lookup('YES_NO', 'N');
3831: Else
3832: l_return := hr_general.decode_lookup('YES_NO', 'Y');
3833: End If;
3834: Close prof_rec;
3835: hr_utility.set_location(' Leaving:' || l_proc,15);
3836: Return l_return;

Line 3840: l_return := hr_general.decode_lookup('YES_NO', 'Y');

3836: Return l_return;
3837: Exception
3838: When OTHERS Then
3839: hr_utility.set_location(' Leaving:' || l_proc,555);
3840: l_return := hr_general.decode_lookup('YES_NO', 'Y');
3841: If prof_rec%ISOPEN Then
3842: hr_utility.set_location(' Leaving:' || l_proc,560);
3843: Close prof_rec;
3844: End If;