APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on PER_ALL_PEOPLE_F

Line 136: FROM Per_All_People_f

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

Line 1866: -- per_all_people_f per,

1862: ,Gl_Import_References Gir
1863: ,Ja_Cn_Code_Combination_v Jcc
1864: ,Ap_Suppliers Sup
1865: ,
1866: -- per_all_people_f per,
1867: Ja_Cn_Journals_Of_Period Jop
1868: ,Hz_Cust_Accounts Cust
1869: ,Hz_Parties Part
1870: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id

Line 2104: FROM PER_ALL_PEOPLE_F

2100:
2101: --get creator's name of journal
2102: UPDATE JA_CN_JOURNAL_LINES_REQ REQ
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 =

Line 2118: FROM PER_ALL_PEOPLE_F

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