DBA Data[Home] [Help]

APPS.JA_CN_GL_BANK_EXP_PKG dependencies on FND_USER

Line 1013: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL, FND_USER FU, FND_USER FU2

1009: TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE, 'YYYY') PERIOD_YEAR,
1010: GJH.JE_HEADER_ID,
1011: GJH.PERIOD_NAME,
1012: GJH.JE_BATCH_ID
1013: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL, FND_USER FU, FND_USER FU2
1014: WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
1015: AND gjh.status = 'P'
1016: AND FU.USER_ID = GJL.CREATED_BY
1017: AND FU2.USER_ID = GJL.LAST_UPDATED_BY

Line 1121: into l_poster from gl_je_batches gjb, fnd_user fu

1117: l_approver := Get_Approver(l_journal.je_header_id,l_journal.CREATOR);
1118: Ja_Cn_Utility.Add_Child_Node('REVIEWER',Get_Fullname(l_approver));
1119: --Ja_Cn_Utility.Add_Child_Node('POSTER',l_journal.POSTER);
1120: select fu.user_name
1121: into l_poster from gl_je_batches gjb, fnd_user fu
1122: where gjb.posted_by = fu.user_id
1123: and gjb.je_batch_id = l_journal.je_batch_id;
1124:
1125: Ja_Cn_Utility.Add_Child_Node('POSTER',Get_Fullname(l_poster));

Line 1198: (select employee_id from fnd_user where user_name = p_username)

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;
1201: EXCEPTION
1202: WHEN NO_DATA_FOUND THEN

Line 1224: FUNCTION Get_Approver(p_je_header pls_integer,p_fnd_user varchar2) return varchar2

1220: END Get_FullName;
1221:
1222:
1223:
1224: FUNCTION Get_Approver(p_je_header pls_integer,p_fnd_user varchar2) return varchar2
1225: as
1226: lv_procedure_name VARCHAR2(40) := 'Get_Approver';
1227: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1228: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 1242: from fnd_user

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
1245: and nvl(effective_end_date, sysdate) >= sysdate)
1246: and user_key =

Line 1243: where user_name = p_fnd_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
1245: and nvl(effective_end_date, sysdate) >= sysdate)
1246: and user_key =
1247: (select name

Line 1257: FROM GL_JE_HEADERS GJH, FND_USER FU2

1253:
1254: EXCEPTION
1255: WHEN NO_DATA_FOUND THEN
1256: SELECT FU2.USER_NAME into l_approver
1257: FROM GL_JE_HEADERS GJH, FND_USER FU2
1258: WHERE GJH.JE_HEADER_ID =p_je_header
1259: AND gjh.status = 'P'
1260: AND FU2.USER_ID = GJH.LAST_UPDATED_BY;
1261: END;