APPS.BSC_APPS dependencies on FND_USER

Line 898: object_name = 'FND_USER';

894: object_name
895: FROM
896: user_objects
897: WHERE
898: object_name = 'FND_USER';
899:
900: h_table VARCHAR2(30);
901: h_status VARCHAR2(2000);
902: h_industry VARCHAR2(2000);

Line 1547: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur

1543: l_count := 0;
1544:
1545: SELECT COUNT(0)
1546: INTO l_count
1547: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur
1548: WHERE fu.User_Id = x_User_Id
1549: AND fu.User_Id = fur.User_Id
1550: AND fr.Responsibility_Id = fur.Responsibility_Id
1551: AND fr.Application_Id = fur.Responsibility_Application_Id

Line 1591: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur

1587: l_count := 0;
1588:
1589: SELECT COUNT(0)
1590: INTO l_count
1591: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur
1592: WHERE fu.User_Id = x_User_Id
1593: AND fu.User_Id = fur.User_Id
1594: AND (fr.responsibility_key = 'BSC_DESIGNER' OR fr.responsibility_key = 'BSC_Manager')
1595: AND fr.Responsibility_Id = fur.Responsibility_Id

Line 1630: FROM PER_ALL_PEOPLE_F P, FND_USER F

1626: l_name VARCHAR2(240) := '';
1627:
1628: CURSOR c_Full_Name IS
1629: SELECT P.FULL_NAME
1630: FROM PER_ALL_PEOPLE_F P, FND_USER F
1631: WHERE P.PERSON_ID = F.EMPLOYEE_ID
1632: AND F.USER_ID = x_User_Id;
1633:
1634: BEGIN