896:
897: BEGIN
898: SELECT employee_id
899: INTO l_employee_id 900: from fnd_user 901: where user_id=to_number(p_user_id);
902: x_Person_id := l_employee_id;
903:
904: BEGIN
Line 943: from fnd_user
939: l_resource_id VARCHAR2(30);
940: BEGIN
941: SELECT employee_id
942: INTO l_employee_id 943: from fnd_user 944: where user_id=to_number(p_user_id);
945: x_Person_id := l_employee_id;
946:
947: SELECT resource_id