859: CURSOR user_resp_csr(p_user_id NUMBER) is
860: select a.responsibility_id, c.application_id,
861: b.responsibility_key, c.application_short_name
862: from fnd_user_resp_groups_all a,
863: fnd_responsibility_vl b,
864: fnd_application c
865: where a.user_id = p_user_id
866: and sysdate between NVL(a.start_date,sysdate) and NVL(a.end_date,sysdate)
867: and a.responsibility_id = b.responsibility_id