APPS.CS_CIC_ATTRIBUTE_PUB dependencies on FND_LOOKUPS

Line 376: FROM Fnd_Lookups

372: FOR i IN p_cic_attribute_code.FIRST .. p_cic_attribute_code.LAST
373: LOOP
374: SELECT Description
375: INTO l_attr_name
376: FROM Fnd_Lookups
377: WHERE Lookup_Code = p_cic_attribute_code(i)
378: AND Lookup_Type = 'CUG_SR_TYPE_ATTRIBUTES';
379:
380: IF (p_cic_attr_lookup(i) IS NOT NULL ) THEN

Line 384: FROM Fnd_Lookups

380: IF (p_cic_attr_lookup(i) IS NOT NULL ) THEN
381: BEGIN
382: SELECT Meaning ,description
383: INTO l_attr_value ,l_attr_description
384: FROM Fnd_Lookups
385: WHERE Lookup_Code = p_cic_attr_value(i)
386: AND Lookup_Type = p_cic_attr_lookup(i);
387: EXCEPTION
388: WHEN OTHERS THEN

Line 584: FROM Fnd_Lookups

580: FOR i IN p_incident_attr_val_id.FIRST .. p_incident_attr_val_id.LAST
581: LOOP
582: SELECT Description
583: INTO l_attr_name
584: FROM Fnd_Lookups
585: WHERE Lookup_Code = p_cic_attribute_code(i)
586: AND Lookup_Type = 'CUG_SR_TYPE_ATTRIBUTES';
587:
588: IF (p_cic_attr_lookup(i) IS NOT NULL) THEN

Line 592: FROM Fnd_Lookups

588: IF (p_cic_attr_lookup(i) IS NOT NULL) THEN
589: BEGIN
590: SELECT Description
591: INTO l_attr_value
592: FROM Fnd_Lookups
593: WHERE Lookup_Code = p_cic_attr_value(i)
594: AND Lookup_Type = p_cic_attr_lookup(i);
595: EXCEPTION
596: WHEN OTHERS THEN