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.POR_RCV_ORD_SV dependencies on PER_PEOPLE_F

Line 597: FROM FND_USER FND, per_people_f HR

593:
594: begin
595: SELECT HR.PERSON_ID
596: INTO x_employee_id
597: FROM FND_USER FND, per_people_f HR
598: WHERE FND.USER_ID = x_user_id
599: AND FND.EMPLOYEE_ID = HR.PERSON_ID
600: AND sysdate between hr.effective_start_date AND hr.effective_end_date
601: AND ROWNUM = 1;

Line 899: FROM FND_USER FND, per_people_f HR

895:
896: begin
897: SELECT HR.PERSON_ID
898: INTO x_employee_id
899: FROM FND_USER FND, per_people_f HR
900: WHERE FND.USER_ID = x_user_id
901: AND FND.EMPLOYEE_ID = HR.PERSON_ID
902: AND sysdate between hr.effective_start_date AND hr.effective_end_date
903: AND ROWNUM = 1;

Line 1427: FROM FND_USER FND, per_people_f HR

1423:
1424: BEGIN
1425: SELECT HR.PERSON_ID
1426: INTO x_employee_id
1427: FROM FND_USER FND, per_people_f HR
1428: WHERE FND.USER_ID = X_created_by
1429: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1430: AND sysdate between hr.effective_start_date AND hr.effective_end_date
1431: AND ROWNUM = 1;