APPS.MTH_EVENT_GEN_PKG dependencies on FND_LOOKUPS

Line 21: FROM MTH_TAG_REASON_READINGS TRR ,FND_LOOKUPS FL

17: TRR.FROM_DATE FROM_DATE,
18: TRR.TO_DATE TO_DATE,
19: TRR.REASON_CODE REASON_CODE,
20: TRR.LAST_UPDATE_DATE LAST_UPDATE_DATE
21: FROM MTH_TAG_REASON_READINGS TRR ,FND_LOOKUPS FL
22: WHERE TRR.LAST_UPDATE_DATE >= v_log_from_date AND
23: TRR.REASON_TYPE = 1 AND
24: TRR.REASON_CODE = FL.LOOKUP_CODE And
25: FL.LOOKUP_TYPE = 'MTH_EQUIP_DOWNTIME_REASON' ;

Line 412: SELECT Count(*) INTO v_count FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');

408: MTH_GEN_HIGH_SCRAP_EVENT (v_log_from_date) ;
409: MTH_GEN_HIGH_REWORK_EVENT (v_log_from_date);
410:
411:
412: SELECT Count(*) INTO v_count FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');
413: IF (v_count>0) THEN
414: SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');
415: l_sql_stmt:= 'BEGIN ' || v_desc || '; END;';
416: BEGIN

Line 414: SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');

410:
411:
412: SELECT Count(*) INTO v_count FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');
413: IF (v_count>0) THEN
414: SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');
415: l_sql_stmt:= 'BEGIN ' || v_desc || '; END;';
416: BEGIN
417: IF(v_desc IS NOT NULL )THEN
418: EXECUTE IMMEDIATE l_sql_stmt;