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.PA_HR_COMPETENCE_UTILS dependencies on PA_RESOURCES_DENORM

Line 456: (p_person_id IN pa_resources_denorm.person_id%TYPE)

452: RAISE;
453: END check_competence_exists;
454:
455: FUNCTION Get_Res_Competences
456: (p_person_id IN pa_resources_denorm.person_id%TYPE)
457: RETURN VARCHAR2 IS
458:
459: TYPE number_tbl IS TABLE OF NUMBER(15);
460: TYPE varchar240_tbl IS TABLE OF VARCHAR(240);

Line 514: (p_person_id IN pa_resources_denorm.person_id%TYPE)

510:
511: END Get_Res_Competences;
512:
513: FUNCTION Get_Res_Competences_Count
514: (p_person_id IN pa_resources_denorm.person_id%TYPE)
515: RETURN NUMBER IS
516: l_count NUMBER;
517: BEGIN
518: SELECT count(*)

Line 532: (p_person_id IN pa_resources_denorm.person_id%TYPE)

528: RAISE;
529: END Get_Res_Competences_Count;
530:
531: FUNCTION Get_Res_Comp_Last_Updated
532: (p_person_id IN pa_resources_denorm.person_id%TYPE)
533: RETURN DATE IS
534: l_date DATE;
535: BEGIN
536: SELECT MAX(last_update_date)