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_UTILS dependencies on PA_EMPLOYEES

Line 162: pa_employees

158: person_id
159: INTO
160: X_person_id
161: FROM
162: pa_employees
163: WHERE
164: employee_number = X_emp_num;
165:
166: RETURN ( X_person_id );

Line 216: pa_employees

212: full_name
213: INTO
214: X_person_name
215: FROM
216: pa_employees
217: WHERE
218: person_id = X_person_id;
219:
220: RETURN ( X_person_name );

Line 1999: -- This Function Can also be used whenever pa_employees is not scanned by index and we want to force index scan on pa_employees view.

1995: -- ==========================================================================
1996: -- FUNCTION GetPersonInfo : Used only in the view PA_PROJECT_PLAYERS_V
1997: -- Returns the requested data in l_data. Returns 'NOT_FOUND' when no records
1998: -- found or invalid l_data
1999: -- This Function Can also be used whenever pa_employees is not scanned by index and we want to force index scan on pa_employees view.
2000: -- ==========================================================================
2001:
2002: FUNCTION GetPersonInfo( p_person_id IN per_all_people_f.person_id%TYPE,
2003: p_data IN VARCHAR2 DEFAULT 'PERSON_ID') RETURN VARCHAR2

Line 2021: from pa_employees where person_id = p_person_id;

2017: , L_PERSON_LAST_NAME
2018: , L_PERSON_FIRST_NAME
2019: , L_PERSON_MIDDLE_NAMES
2020: , L_PERSON_EMPLOYEE_NUMBER
2021: from pa_employees where person_id = p_person_id;
2022: Exception
2023: When No_Data_Found Then
2024: RETURN('NOT_FOUND');
2025: END;