DBA Data[Home] [Help]

APPS.HZ_DSS_GRANTS_PUB dependencies on FND_GLOBAL

Line 1351: WHERE rg.user_id = fnd_global.user_id

1347: BEGIN
1348: SELECT 1
1349: INTO l_resp_cnt
1350: FROM fnd_user_resp_groups rg
1351: WHERE rg.user_id = fnd_global.user_id
1352: AND rg.responsibility_id = G_DSS_RESPONSIBILITY_ID
1353: AND rg.responsibility_application_id = 222
1354: AND (rg.end_date IS NULL OR rg.end_date > SYSDATE)
1355: AND (rg.start_date IS NULL OR rg.start_date < SYSDATE);