APPS.GMD_API_GRP dependencies on FND_USER

Line 1031: FROM FND_USER_RESP_GROUPS rg

1027: FROM gmd_security_profiles sp
1028: WHERE sp.access_type_ind = 'U'
1029: AND nvl(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1030: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1031: FROM FND_USER_RESP_GROUPS rg
1032: WHERE rg.user_id = fnd_global.user_id
1033: AND SYSDATE BETWEEN rg.start_date
1034: AND NVL(rg.end_date, SYSDATE)
1035: )

Line 1067: FROM FND_USER_RESP_GROUPS rg

1063: AND ( ( sp.user_id = V_default_user_id
1064: OR sp.user_id = fnd_global.user_id
1065: )
1066: OR ( EXISTS ( SELECT rg.responsibility_id
1067: FROM FND_USER_RESP_GROUPS rg
1068: WHERE rg.user_id = fnd_global.user_id
1069: AND sp.responsibility_id = rg.responsibility_id
1070: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)
1071: )

Line 1104: FROM FND_USER_RESP_GROUPS rg

1100: WHERE ( ( fs.user_id = V_default_user_id
1101: OR fs.user_id = fnd_global.user_id
1102: )
1103: OR ( EXISTS ( SELECT rg.responsibility_id
1104: FROM FND_USER_RESP_GROUPS rg
1105: WHERE rg.user_id = fnd_global.user_id
1106: AND fs.responsibility_id = rg.responsibility_id
1107: AND SYSDATE BETWEEN rg.start_date
1108: AND NVL(rg.end_date, SYSDATE)

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

1727: l_recipe_version NUMBER(5) := 1;
1728: l_delete_mark NUMBER(5);
1729: l_recipe_name NUMBER(5);
1730: i BINARY_INTEGER := 2;
1731: l_user_id FND_USER.user_id%TYPE; --NUMBER;
1732: l_login_id NUMBER;
1733: l_recipe_no VARCHAR2(32);
1734: l_orgn_ID NUMBER;
1735: l_item_id NUMBER;