DBA Data[Home] [Help]

APPS.IEM_TAGPROCESS_PUB dependencies on FND_USER

Line 1028: fnd_user_resp_groups b, fnd_user c, fnd_responsibility resp

1024: return false;
1025: end if;
1026:
1027: select count(a.user_id) into l_user_resp from jtf_rs_resource_extns a ,
1028: fnd_user_resp_groups b, fnd_user c, fnd_responsibility resp
1029: where a.resource_id = p_agent_id
1030: and a.START_DATE_ACTIVE< sysdate and ( a.END_DATE_ACTIVE>sysdate or a.END_DATE_ACTIVE is null)
1031: and a.user_id=b.user_id
1032: and b.START_DATE< sysdate and ( b.END_DATE>sysdate or b.END_DATE is null)