1736: where usr.user_name = 'SYSADMIN';
1737: --
1738: cursor c_get_responsibility_id(p_user_id number) is
1739: select fur.responsibility_id, fur.responsibility_application_id
1740: from fnd_user_resp_groups fur
1741: where fur.user_id = p_user_id
1742: order by fur.responsibility_id;
1743: --
1744: cursor c_get_application_id(p_resp_id number) is
1844: where usr.user_name = 'SYSADMIN';
1845: --
1846: cursor c_get_responsibility_id(p_user_id number) is
1847: select fur.responsibility_id, fur.responsibility_application_id
1848: from fnd_user_resp_groups fur
1849: where fur.user_id = p_user_id
1850: order by fur.responsibility_id;
1851: --
1852: cursor c_get_application_id(p_resp_id number) is