DBA Data[Home] [Help]

APPS.JA_CN_GL_BANK_EXP_PKG dependencies on PER_ALL_PEOPLE_F

Line 1196: from PER_ALL_PEOPLE_F

1192: l_fullname varchar2(50);
1193: BEGIN
1194: BEGIN
1195: select full_name into l_fullname
1196: from PER_ALL_PEOPLE_F
1197: where person_id =
1198: (select employee_id from fnd_user where user_name = p_username)
1199: and nvl(effective_start_date, sysdate) <= sysdate
1200: and nvl(effective_end_date, sysdate) >= sysdate;

Line 1240: from PER_ALL_PEOPLE_F ff

1236: (select max(item_key) item_key, max(notification_id) notification_id
1237: from wf_notifications
1238: where from_user =
1239: (select global_name
1240: from PER_ALL_PEOPLE_F ff
1241: where person_id = (select employee_id
1242: from fnd_user
1243: where user_name = p_fnd_user)
1244: and nvl(effective_start_date, sysdate) <= sysdate