DBA Data[Home] [Help]

APPS.HZ_DSS_UTIL_PUB dependencies on FND_USER

Line 132: FROM fnd_user

128: ) RETURN VARCHAR2 IS
129:
130: CURSOR c_check_user IS
131: SELECT '1'
132: FROM fnd_user
133: WHERE user_name = p_user_name
134: AND (start_date IS NULL OR start_date <= SYSDATE)
135: AND (end_date IS NULL OR end_date >= SYSDATE);
136:

Line 383: from fnd_user

379: begin
380:
381: select '1'
382: into l_exists
383: from fnd_user
384: where user_name = p_user_name
385: and ( start_date IS NULL OR start_date <= SYSDATE)
386: and ( end_date is null or end_date >= sysdate );
387:

Line 1267: l_user_name fnd_user.user_name%type;

1263:
1264: x_granted_groups HZ_DSS_UTIL_PUB.dss_group_tbl_type;
1265:
1266: i number;
1267: l_user_name fnd_user.user_name%type;
1268: l_return_status VARCHAR2(1);
1269: l_msg_count NUMBER;
1270: l_msg_data VARCHAR2(2000);
1271: