DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on FND_LOOKUPS

Line 730: FND_LOOKUPS FLS ,

726: , JNT.NOTES Note_Description
727: , JNT.NOTES_DETAIL Note_Detail
728: FROM JTF_NOTES_B JNB ,
729: JTF_NOTES_TL JNT ,
730: FND_LOOKUPS FLS ,
731: FND_LOOKUPS FLP,
732: jtf_rs_resource_extns ext_userb,
733: jtf_rs_resource_extns_tl ext_usert,
734: FND_USER fnd1

Line 731: FND_LOOKUPS FLP,

727: , JNT.NOTES_DETAIL Note_Detail
728: FROM JTF_NOTES_B JNB ,
729: JTF_NOTES_TL JNT ,
730: FND_LOOKUPS FLS ,
731: FND_LOOKUPS FLP,
732: jtf_rs_resource_extns ext_userb,
733: jtf_rs_resource_extns_tl ext_usert,
734: FND_USER fnd1
735: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID

Line 1451: FROM fnd_lookups fnd1,

1447:
1448: --:escalation
1449: CURSOR Get_Escalation (v_incident_id NUMBER) IS
1450: SELECT fnd1.meaning escalation_level
1451: FROM fnd_lookups fnd1,
1452: jtf_task_references_b r,
1453: jtf_tasks_b t
1454: WHERE fnd1.lookup_type = 'JTF_EC_ESC_LEVEL'and
1455: fnd1.lookup_code = t.escalation_level and