DBA Data[Home] [Help]

APPS.BSC_APPS dependencies on PER_ALL_PEOPLE_F

Line 1620: | per_all_people_f table

1616: /*===========================================================================+
1617: | Name: GET_USER_FULL_NAME
1618: |
1619: | Description: This fucntion return teh full name of the user from
1620: | per_all_people_f table
1621: | Notes: Revamped API to call static cursor for Bug 3236356
1622: +============================================================================*/
1623: FUNCTION Get_User_Full_Name (
1624: x_User_Id in NUMBER

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