APPS.IEM_EMAIL_PROC_PVT dependencies on FND_LOOKUPS

Line 2529: from fnd_lookups

2525: -- Selecting Auto Ack. Subject which will be appended to original mail
2526: BEGIN
2527: select meaning||': '
2528: into l_ack_sub
2529: from fnd_lookups
2530: where lookup_type='IEM_AUTO_ACKNOWLEDGE'
2531: and lookup_code='SUBJECT';
2532: l_subject:=substr(l_ack_sub||p_subject,1,240);
2533: EXCEPTION WHEN OTHERS THEN

Line 3508: from fnd_lookups

3504: x_qual_tbl out nocopy IEM_OUTBOX_PROC_PUB.QualifierRecordList,
3505: x_status out nocopy varchar2,
3506: x_out_text out nocopy varchar2) IS
3507: cursor c1 is select lookup_code,meaning
3508: from fnd_lookups
3509: where enabled_flag = 'Y'
3510: AND NVL(start_date_active, SYSDATE) <= SYSDATE
3511: AND NVL(end_date_active,SYSDATE) >= SYSDATE
3512: AND lookup_type ='IEM_MERGE_FIELDS'