DBA Data[Home] [Help]

APPS.HR_UTILITY dependencies on FND_USER

Line 1735: from fnd_user usr

1731: l_application_id number;
1732: --
1733: cursor c_sysadmin_usr is
1734: select usr.user_id
1735: from fnd_user usr
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

Line 1740: from fnd_user_resp_groups fur

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

Line 1843: from fnd_user usr

1839: l_temp_application_id number;
1840: --
1841: cursor c_sysadmin_usr is
1842: select usr.user_id
1843: from fnd_user usr
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

Line 1848: from fnd_user_resp_groups fur

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