DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on FND_LOOKUPS

Line 708: FND_LOOKUPS FLS ,

704: , JNT.NOTES Note_Description
705: , JNT.NOTES_DETAIL Note_Detail
706: FROM JTF_NOTES_B JNB ,
707: JTF_NOTES_TL JNT ,
708: FND_LOOKUPS FLS ,
709: FND_LOOKUPS FLP,
710: jtf_rs_resource_extns ext_userb,
711: jtf_rs_resource_extns_tl ext_usert,
712: FND_USER fnd1

Line 709: FND_LOOKUPS FLP,

705: , JNT.NOTES_DETAIL Note_Detail
706: FROM JTF_NOTES_B JNB ,
707: JTF_NOTES_TL JNT ,
708: FND_LOOKUPS FLS ,
709: FND_LOOKUPS FLP,
710: jtf_rs_resource_extns ext_userb,
711: jtf_rs_resource_extns_tl ext_usert,
712: FND_USER fnd1
713: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID

Line 1380: FROM fnd_lookups fnd1,

1376:
1377: --:escalation
1378: CURSOR Get_Escalation (v_incident_id NUMBER) IS
1379: SELECT fnd1.meaning escalation_level
1380: FROM fnd_lookups fnd1,
1381: jtf_task_references_b r,
1382: jtf_tasks_b t
1383: WHERE fnd1.lookup_type = 'JTF_EC_ESC_LEVEL'and
1384: fnd1.lookup_code = t.escalation_level and