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.GMS_CLIENT_EXTN_BUDGET_WF dependencies on PER_ALL_PEOPLE_F

Line 253: min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =

249: IS
250: SELECT p.first_name||' '||p.last_name
251: FROM fnd_user f, per_people_f p /*Bug 5122724 */
252: where p.effective_start_date = (select
253: min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =
254: p.person_id and pp.effective_end_date >=trunc(sysdate)) and
255: ((p.employee_number is not null) or (p.npw_number is not null))
256: and f.user_id = p_starter_user_id
257: and f.employee_id = p.person_id;

Line 260: FROM fnd_user f, per_all_people_f e --pa_employees e Commented for Bug5067575, SQLId:16329634

256: and f.user_id = p_starter_user_id
257: and f.employee_id = p.person_id;
258: /* Replaced below sql with above sql for Bug 5122724
259: SELECT e.first_name||' '||e.last_name
260: FROM fnd_user f, per_all_people_f e --pa_employees e Commented for Bug5067575, SQLId:16329634
261: WHERE f.user_id = p_starter_user_id
262: AND f.employee_id = e.person_id
263: AND rownum=1; -- Added for Bug5067575, SQLId:16329634 */
264: --

Line 991: min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =

987: IS
988: SELECT p.first_name||' '||p.last_name /* Bug 5122724 */
989: FROM fnd_user f, per_people_f p
990: where p.effective_start_date = (select
991: min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =
992: p.person_id and pp.effective_end_date >=trunc(sysdate)) and
993: ((p.employee_number is not null) or (p.npw_number is not null))
994: and f.user_id = p_starter_user_id
995: and f.employee_id = p.person_id;

Line 998: FROM fnd_user f, per_all_people_f e --pa_employees e Commented for Bug5067575, SQLId:16329634

994: and f.user_id = p_starter_user_id
995: and f.employee_id = p.person_id;
996: /* Replaced below sql with above sql for Bug 5122724
997: SELECT e.first_name||' '||e.last_name
998: FROM fnd_user f, per_all_people_f e --pa_employees e Commented for Bug5067575, SQLId:16329634
999: WHERE f.user_id = p_starter_user_id
1000: AND f.employee_id = e.person_id
1001: AND rownum=1; -- Added for Bug5067575, SQLId:16329634 */
1002: --