DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_USER

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

134: CURSOR c_Approver_Name IS
135: SELECT Last_Name || First_Name Full_Name
136: FROM Per_All_People_f
137: WHERE Person_Id =
138: (SELECT Employee_Id FROM Fnd_User WHERE User_Name = l_Approver);
139:
140: BEGIN
141: --log
142: IF (l_Proc_Level >= l_Dbg_Level) THEN

Line 2107: FROM FND_USER

2103: SET REQ.JOURNAL_CREATOR = (SELECT LAST_NAME || FIRST_NAME FULL_NAME
2104: FROM PER_ALL_PEOPLE_F
2105: WHERE PERSON_ID =
2106: (SELECT EMPLOYEE_ID
2107: FROM FND_USER
2108: WHERE USER_ID =
2109: REQ.JOURNAL_CREATED_BY)
2110: AND REQ.DEFAULT_EFFECTIVE_DATE BETWEEN
2111: EFFECTIVE_START_DATE AND

Line 2121: FROM FND_USER

2117: SET REQ.JOURNAL_POSTER = (SELECT LAST_NAME || FIRST_NAME FULL_NAME
2118: FROM PER_ALL_PEOPLE_F
2119: WHERE PERSON_ID =
2120: (SELECT EMPLOYEE_ID
2121: FROM FND_USER
2122: WHERE USER_ID =
2123: REQ.JOURNAL_POSTED_BY)
2124: AND REQ.DEFAULT_EFFECTIVE_DATE BETWEEN
2125: EFFECTIVE_START_DATE AND