39: select a.responsibility_id,
40: a.responsibility_key,
41: a.responsibility_name
42: from fnd_responsibility_vl a,
43: fnd_user_resp_groups b
44: where b.user_id = p_user_id
45: and b.responsibility_id = a.responsibility_id
46: and b.start_date <= sysdate
47: and (b.end_date is null or b.end_date >= sysdate)
96: select a.responsibility_id,
97: a.responsibility_key,
98: a.responsibility_name
99: from fnd_responsibility_vl a,
100: fnd_user_resp_groups b
101: where b.user_id = p_user_id
102: and b.responsibility_id = a.responsibility_id
103: and b.start_date <= sysdate
104: and (b.end_date is null or b.end_date >= sysdate)