60: )
61: IS
62:
63: l_employee_id FND_USER.EMPLOYEE_ID%TYPE;
64: l_user_party_id HZ_PARTIES.PARTY_ID%TYPE;
65: l_enterprise_id HZ_PARTIES.PARTY_ID%TYPE;
66: l_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
67: l_step NUMBER;
68: l_username FND_USER.USER_NAME%TYPE;
61: IS
62:
63: l_employee_id FND_USER.EMPLOYEE_ID%TYPE;
64: l_user_party_id HZ_PARTIES.PARTY_ID%TYPE;
65: l_enterprise_id HZ_PARTIES.PARTY_ID%TYPE;
66: l_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
67: l_step NUMBER;
68: l_username FND_USER.USER_NAME%TYPE;
69: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;