APPS.GMD_API_GRP dependencies on FND_USER

Line 1027: FROM FND_USER_RESP_GROUPS rg

1023: WHERE EXISTS ( SELECT 1
1024: FROM gmd_security_profiles sp
1025: WHERE sp.access_type_ind = 'U'
1026: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1027: FROM FND_USER_RESP_GROUPS rg
1028: WHERE rg.user_id = fnd_global.user_id
1029: AND SYSDATE BETWEEN rg.start_date
1030: AND NVL(rg.end_date, SYSDATE)
1031: )

Line 1062: FROM FND_USER_RESP_GROUPS rg

1058: AND ( ( sp.user_id = V_default_user_id
1059: OR sp.user_id = fnd_global.user_id
1060: )
1061: OR ( EXISTS ( SELECT rg.responsibility_id
1062: FROM FND_USER_RESP_GROUPS rg
1063: WHERE rg.user_id = fnd_global.user_id
1064: AND sp.responsibility_id = rg.responsibility_id
1065: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)
1066: )

Line 1099: FROM FND_USER_RESP_GROUPS rg

1095: WHERE ( ( fs.user_id = V_default_user_id
1096: OR fs.user_id = fnd_global.user_id
1097: )
1098: OR ( EXISTS ( SELECT rg.responsibility_id
1099: FROM FND_USER_RESP_GROUPS rg
1100: WHERE rg.user_id = fnd_global.user_id
1101: AND fs.responsibility_id = rg.responsibility_id
1102: AND SYSDATE BETWEEN rg.start_date
1103: AND NVL(rg.end_date, SYSDATE)

Line 1717: l_user_id FND_USER.user_id%TYPE; --NUMBER;

1713: l_recipe_version NUMBER(5) := 1;
1714: l_delete_mark NUMBER(5);
1715: l_recipe_name NUMBER(5);
1716: i BINARY_INTEGER := 2;
1717: l_user_id FND_USER.user_id%TYPE; --NUMBER;
1718: l_login_id NUMBER;
1719: l_recipe_no VARCHAR2(32);
1720: l_orgn_ID NUMBER;
1721: l_item_id NUMBER;