APPS.JA_CN_GL_BANK_EXP_PKG dependencies on GL_JE_BATCHES

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 1248: from gl_je_batches gjb

1244: and nvl(effective_start_date, sysdate) <= sysdate
1245: and nvl(effective_end_date, sysdate) >= sysdate)
1246: and user_key =
1247: (select name
1248: from gl_je_batches gjb
1249: where gjb.je_batch_id =
1250: (select gjh.je_batch_id
1251: from gl_je_headers gjh
1252: where gjh.je_header_id = p_je_header)));