APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on PER_ALL_PEOPLE_F

Line 117: FROM Per_All_People_f

113: -- group by it.item_key);
114:
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

Line 1451: -- per_all_people_f per,

1447: ,Gl_Import_References Gir
1448: ,Ja_Cn_Code_Combination_v Jcc
1449: ,Ap_Suppliers Sup
1450: ,
1451: -- per_all_people_f per,
1452: Ja_Cn_Journals_Of_Period Jop
1453: ,Hz_Cust_Accounts Cust
1454: ,Hz_Parties Part
1455: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id

Line 1661: FROM PER_ALL_PEOPLE_F

1657:
1658: --get creator's name of journal
1659: UPDATE JA_CN_JOURNAL_LINES_REQ REQ
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 =

Line 1675: FROM PER_ALL_PEOPLE_F

1671: AND REQ.JE_HEADER_ID > 0;
1672: --get poster's name of journals
1673: UPDATE JA_CN_JOURNAL_LINES_REQ REQ
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 =