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.PERCOMPSTATUS dependencies on STANDARD

Line 33: IF l_competence_cluster = 'UNIT_STANDARD' then

29: l_achieved_date per_competence_elements.Achieved_date%type;
30: begin
31: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl
32: WHERE competence_id = p_competence_id;
33: IF l_competence_cluster = 'UNIT_STANDARD' then
34: IF p_competence_element_id IS NOT NULL then
35: -- added for the 4187713 bug.
36: -- Getting the End date outcome rec which were achieved earlier.
37: Select pce.status, pce.Achieved_date, pce.person_id

Line 240: IF l_competence_cluster = 'UNIT_STANDARD' then

236: l_comp_status per_competence_elements.status%type;
237: begin
238: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl
239: WHERE competence_id = p_competence_id;
240: IF l_competence_cluster = 'UNIT_STANDARD' then
241: IF p_competence_element_id IS NOT NULL OR p_competence_element_id > 0 then
242: l_comp_status := Get_Competence_Status(
243: p_competence_id => p_competence_id
244: ,p_competence_element_id => p_competence_element_id