APPS.IEM_EMAIL_PROC_PVT dependencies on FND_LOOKUPS

Line 3624: from fnd_lookups

3620: -- Selecting Auto Ack. Subject which will be appended to original mail
3621: BEGIN
3622: select meaning||': '
3623: into l_ack_sub
3624: from fnd_lookups
3625: where lookup_type='IEM_AUTO_ACKNOWLEDGE'
3626: and lookup_code='SUBJECT';
3627: l_subject:=substr(l_ack_sub||p_subject,1,240);
3628: EXCEPTION WHEN OTHERS THEN

Line 4603: from fnd_lookups

4599: x_qual_tbl out nocopy IEM_OUTBOX_PROC_PUB.QualifierRecordList,
4600: x_status out nocopy varchar2,
4601: x_out_text out nocopy varchar2) IS
4602: cursor c1 is select lookup_code,meaning
4603: from fnd_lookups
4604: where enabled_flag = 'Y'
4605: AND NVL(start_date_active, SYSDATE) <= SYSDATE
4606: AND NVL(end_date_active,SYSDATE) >= SYSDATE
4607: AND lookup_type ='IEM_MERGE_FIELDS'