DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_USER

Line 119: (SELECT Employee_Id FROM Fnd_User WHERE User_Name = l_Approver);

115: CURSOR c_Approver_Name IS
116: SELECT Last_Name || First_Name Full_Name
117: FROM Per_All_People_f
118: WHERE Person_Id =
119: (SELECT Employee_Id FROM Fnd_User WHERE User_Name = l_Approver);
120:
121: BEGIN
122: --log
123: IF (l_Proc_Level >= l_Dbg_Level) THEN

Line 1664: FROM FND_USER

1660: SET REQ.JOURNAL_CREATOR = (SELECT LAST_NAME || FIRST_NAME FULL_NAME
1661: FROM PER_ALL_PEOPLE_F
1662: WHERE PERSON_ID =
1663: (SELECT EMPLOYEE_ID
1664: FROM FND_USER
1665: WHERE USER_ID =
1666: REQ.JOURNAL_CREATED_BY)
1667: AND REQ.DEFAULT_EFFECTIVE_DATE BETWEEN
1668: EFFECTIVE_START_DATE AND

Line 1678: FROM FND_USER

1674: SET REQ.JOURNAL_POSTER = (SELECT LAST_NAME || FIRST_NAME FULL_NAME
1675: FROM PER_ALL_PEOPLE_F
1676: WHERE PERSON_ID =
1677: (SELECT EMPLOYEE_ID
1678: FROM FND_USER
1679: WHERE USER_ID =
1680: REQ.JOURNAL_POSTED_BY)
1681: AND REQ.DEFAULT_EFFECTIVE_DATE BETWEEN
1682: EFFECTIVE_START_DATE AND