APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on FND_LOOKUPS

Line 752: FROM fnd_lookups

748:
749: BEGIN
750: SELECT lookup_code
751: INTO l_est_status_code
752: FROM fnd_lookups
753: WHERE lookup_type = 'CSD_ESTIMATE_STATUS'
754: AND lookup_code = x_estimate_rec.estimate_status;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN

Line 1004: FROM fnd_lookups

1000:
1001: BEGIN
1002: SELECT lookup_code
1003: INTO l_est_status_code
1004: FROM fnd_lookups
1005: WHERE lookup_type = 'CSD_ESTIMATE_STATUS'
1006: AND lookup_code = x_estimate_rec.estimate_status;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN

Line 3949: FROM fnd_lookups

3945: l_repair_mode_name VARCHAR2(80) := '';
3946: BEGIN
3947: SELECT meaning
3948: INTO l_repair_mode_name
3949: FROM fnd_lookups
3950: WHERE lookup_type = 'CSD_REPAIR_MODE'
3951: AND lookup_code = p_repair_mode;
3952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_INAPPL_MODE');
3953: Fnd_Message.SET_TOKEN('MODE', l_repair_mode_name);

Line 7569: FROM CSD_REPAIR_ESTIMATE est, fnd_lookups lkp

7565: CURSOR c_cur_repair_estimate_info IS
7566: SELECT est.repair_estimate_id,
7567: est.estimate_status,
7568: lkp.meaning
7569: FROM CSD_REPAIR_ESTIMATE est, fnd_lookups lkp
7570: WHERE est.repair_line_id = p_repair_line_id
7571: and lkp.lookup_code = est.estimate_status
7572: and lkp.lookup_type = 'CSD_ESTIMATE_STATUS'
7573: and rownum = 1;