APPS.MTH_UDA_PKG dependencies on MTH_TAG_READINGS_T_STG

Line 827: SELECT DISTINCT DB_COL FROM MTH_TAG_READINGS_T_STG;

823: v_tl_colname VARCHAR2(30);
824: v_stmt VARCHAR2(32767);
825: v_stmt_no NUMBER;
826: CURSOR DISTINCT_COLUMN IS
827: SELECT DISTINCT DB_COL FROM MTH_TAG_READINGS_T_STG;
828:
829:
830: BEGIN
831:

Line 839: SELECT * FROM MTH_TAG_READINGS_T_STG,(SELECT NVL(FND_GLOBAL.User_Id,-1)l_updated_by,NVL(FND_GLOBAL.Login_Id,-1)l_last_update_login FROM DUAL )D

835: v_colname := DBCOL.DB_COL;
836: v_stmt_no := 10;
837: v_stmt := 'MERGE INTO MTH_EQUIPMENTS_EXT_B ED
838: USING (
839: SELECT * FROM MTH_TAG_READINGS_T_STG,(SELECT NVL(FND_GLOBAL.User_Id,-1)l_updated_by,NVL(FND_GLOBAL.Login_Id,-1)l_last_update_login FROM DUAL )D
840: WHERE DB_COL = '||''''||v_colname||''''||') TS
841: ON (';
842:
843: v_stmt := v_stmt||'ED.EQUIPMENT_PK_KEY = TS.EQUIPMENT_FK_KEY AND