APPS.POR_RCV_ORD_SV dependencies on FND_USER

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 598: WHERE FND.USER_ID = x_user_id

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;
602: EXCEPTION

Line 900: FROM FND_USER FND, per_people_f HR

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

Line 901: WHERE FND.USER_ID = x_user_id

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

Line 1434: FROM FND_USER FND, per_people_f HR

1430:
1431: BEGIN
1432: SELECT HR.PERSON_ID
1433: INTO x_employee_id
1434: FROM FND_USER FND, per_people_f HR
1435: WHERE FND.USER_ID = X_created_by
1436: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1437: AND sysdate between hr.effective_start_date AND hr.effective_end_date
1438: AND ROWNUM = 1;

Line 1435: WHERE FND.USER_ID = X_created_by

1431: BEGIN
1432: SELECT HR.PERSON_ID
1433: INTO x_employee_id
1434: FROM FND_USER FND, per_people_f HR
1435: WHERE FND.USER_ID = X_created_by
1436: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1437: AND sysdate between hr.effective_start_date AND hr.effective_end_date
1438: AND ROWNUM = 1;
1439: EXCEPTION