APPS.CAC_VIEW_ACC_DAILY_VIEW_PVT dependencies on FND_LOOKUPS

Line 242: FROM fnd_lookups

238: l_min_text VARCHAR2(240);
239:
240: CURSOR c_time_uom (b_code VARCHAR2) IS
241: SELECT meaning
242: FROM fnd_lookups
243: WHERE lookup_type = 'CAC_VIEW_DURATION'
244: AND lookup_code = b_code;
245:
246: l_min_code VARCHAR2(10);

Line 328: FROM fnd_lookups

324: RETURN VARCHAR2
325: IS
326: CURSOR c_reminder (b_min VARCHAR2) IS
327: SELECT meaning
328: FROM fnd_lookups
329: WHERE lookup_type = 'JTF_CALND_REMIND_ME'
330: AND lookup_code = b_min;
331:
332: l_reminder VARCHAR2(30);

Line 647: FROM fnd_lookups

643: RETURN VARCHAR2
644: IS
645: CURSOR c_weekdays IS
646: SELECT meaning
647: FROM fnd_lookups
648: WHERE lookup_type = 'JTF_CALND_WEEKDAYS'
649: AND ( (lookup_code = decode(NVL(p_sunday,'N'), 'Y','1','0')) OR
650: (lookup_code = decode(NVL(p_monday,'N'), 'Y','2','0')) OR
651: (lookup_code = decode(NVL(p_tuesday,'N'), 'Y','3','0')) OR

Line 836: FROM fnd_lookups

832: RETURN VARCHAR2
833: IS
834: CURSOR c_occurs_which IS
835: SELECT lower(meaning)
836: FROM fnd_lookups
837: WHERE lookup_type = 'JTF_TASK_RECUR_OCCURS'
838: AND lookup_code = p_occurs_which;
839:
840: l_weekdays VARCHAR2(240);

Line 950: FROM fnd_lookups

946: RETURN VARCHAR2
947: IS
948: CURSOR c_occurs_which IS
949: SELECT meaning
950: FROM fnd_lookups
951: WHERE lookup_type = 'JTF_TASK_RECUR_OCCURS'
952: AND lookup_code = p_occurs_which;
953:
954: l_weekdays VARCHAR2(240);