APPS.JTF_TASK_UTL dependencies on FND_LOOKUPS

Line 49: FROM jtf_tasks_b, fnd_lookups lookups

45: l_meaning VARCHAR2(30);
46: BEGIN
47: SELECT lookups.meaning
48: INTO l_meaning
49: FROM jtf_tasks_b, fnd_lookups lookups
50: WHERE task_id IN (SELECT task_id
51: FROM jtf_task_references_b
52: WHERE object_id = p_task_id
53: AND object_type_code = 'TASK'

Line 275: FROM fnd_lookups

271: x NUMBER;
272: BEGIN
273: SELECT 1
274: INTO x
275: FROM fnd_lookups
276: WHERE lookup_type = p_lookup_type
277: AND lookup_code = p_lookup_code;
278: RETURN TRUE;
279: EXCEPTION

Line 778: FROM fnd_lookups

774: IS
775: CURSOR c_reference_codes
776: IS
777: SELECT 1
778: FROM fnd_lookups
779: WHERE lookup_type = 'JTF_TASK_REFERENCE_CODES'
780: AND lookup_code = p_reference_code;
781:
782: x CHAR;

Line 2707: l_description fnd_lookups.description%TYPE;

2703: p_lookup_code IN VARCHAR2
2704: )
2705: RETURN VARCHAR2
2706: IS
2707: l_description fnd_lookups.description%TYPE;
2708: BEGIN
2709: SELECT description
2710: INTO l_description
2711: FROM fnd_lookups

Line 2711: FROM fnd_lookups

2707: l_description fnd_lookups.description%TYPE;
2708: BEGIN
2709: SELECT description
2710: INTO l_description
2711: FROM fnd_lookups
2712: WHERE lookup_type = p_lookup_type
2713: AND lookup_code = p_lookup_code;
2714: RETURN l_description;
2715: EXCEPTION