eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_TARGET_PVT dependencies on BISBV_TARGETS

Line 160: FROM BISBV_TARGETS bisbv_targets

156: --
157: -- validate that record does not exist already
158: SELECT COUNT(1)
159: INTO l_count
160: FROM BISBV_TARGETS bisbv_targets
161: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
162: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
164: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')

Line 161: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID

157: -- validate that record does not exist already
158: SELECT COUNT(1)
159: INTO l_count
160: FROM BISBV_TARGETS bisbv_targets
161: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
162: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
164: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')

Line 162: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID

158: SELECT COUNT(1)
159: INTO l_count
160: FROM BISBV_TARGETS bisbv_targets
161: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
162: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
164: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
166: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')

Line 163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')

159: INTO l_count
160: FROM BISBV_TARGETS bisbv_targets
161: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
162: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
164: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
166: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
167: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')

Line 165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')

161: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
162: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
164: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
166: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
167: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
168: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
169: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')

Line 167: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')

163: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
164: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
166: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
167: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
168: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
169: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
170: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
171: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')

Line 169: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')

165: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
166: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
167: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
168: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
169: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
170: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
171: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
172: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
173: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')

Line 171: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')

167: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
168: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
169: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
170: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
171: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
172: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
173: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
174: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
175: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')

Line 173: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')

169: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
170: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
171: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
172: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
173: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
174: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
175: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
176: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
177: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')

Line 175: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')

171: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
172: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
173: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
174: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
175: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
176: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
177: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
178: = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
179: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')

Line 177: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')

173: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
174: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
175: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
176: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
177: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
178: = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
179: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')
180: = NVL(l_Target_Rec.Dim7_Level_Value_ID, 'Y');
181:

Line 179: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')

175: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
176: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
177: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
178: = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
179: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')
180: = NVL(l_Target_Rec.Dim7_Level_Value_ID, 'Y');
181:
182: -- dbms_output.put_line( ' Inside pvt : 14 ' );
183:

Line 1240: SELECT bisbv_targets.TARGET_ID

1236:
1237: --
1238: BEGIN
1239:
1240: SELECT bisbv_targets.TARGET_ID
1241: INTO l_target_id
1242: FROM BISBV_TARGETS bisbv_targets
1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID

Line 1242: FROM BISBV_TARGETS bisbv_targets

1238: BEGIN
1239:
1240: SELECT bisbv_targets.TARGET_ID
1241: INTO l_target_id
1242: FROM BISBV_TARGETS bisbv_targets
1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
1246: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')

Line 1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID

1239:
1240: SELECT bisbv_targets.TARGET_ID
1241: INTO l_target_id
1242: FROM BISBV_TARGETS bisbv_targets
1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
1246: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')

Line 1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID

1240: SELECT bisbv_targets.TARGET_ID
1241: INTO l_target_id
1242: FROM BISBV_TARGETS bisbv_targets
1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
1246: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
1248: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')

Line 1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')

1241: INTO l_target_id
1242: FROM BISBV_TARGETS bisbv_targets
1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
1246: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
1248: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
1249: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')

Line 1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')

1243: WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
1244: AND bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
1246: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
1248: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
1249: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
1250: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
1251: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')

Line 1249: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')

1245: AND NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
1246: = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
1248: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
1249: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
1250: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
1251: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
1252: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
1253: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')

Line 1251: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')

1247: AND NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
1248: = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
1249: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
1250: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
1251: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
1252: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
1253: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
1254: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
1255: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')

Line 1253: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')

1249: AND NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
1250: = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
1251: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
1252: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
1253: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
1254: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
1255: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
1256: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
1257: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')

Line 1255: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')

1251: AND NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
1252: = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
1253: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
1254: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
1255: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
1256: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
1257: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
1258: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
1259: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')

Line 1257: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')

1253: AND NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
1254: = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
1255: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
1256: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
1257: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
1258: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
1259: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
1260: = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
1261: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')

Line 1259: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')

1255: AND NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
1256: = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
1257: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
1258: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
1259: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
1260: = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
1261: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')
1262: = NVL(l_Target_Rec.Dim7_Level_Value_ID, 'Y');
1263:

Line 1261: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')

1257: AND NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
1258: = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
1259: AND NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
1260: = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
1261: AND NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')
1262: = NVL(l_Target_Rec.Dim7_Level_Value_ID, 'Y');
1263:
1264: --
1265:

Line 1388: FROM BISBV_TARGETS BISBV_TARGETS

1384: OR x_Target_Rec.TARGET_ID IS NULL
1385: ) THEN
1386: SELECT TARGET_ID
1387: INTO x_Target_Rec.TARGET_ID
1388: FROM BISBV_TARGETS BISBV_TARGETS
1389: WHERE BISBV_TARGETS.TARGET_LEVEL_ID = x_Target_Rec.Target_Level_ID
1390: AND BISBV_TARGETS.PLAN_ID = x_Target_Rec.Plan_ID
1391: AND NVL(BISBV_TARGETS.ORG_LEVEL_VALUE_ID, 'T')
1392: = DECODE( x_Target_Rec.Org_Level_Value_ID

Line 1389: WHERE BISBV_TARGETS.TARGET_LEVEL_ID = x_Target_Rec.Target_Level_ID

1385: ) THEN
1386: SELECT TARGET_ID
1387: INTO x_Target_Rec.TARGET_ID
1388: FROM BISBV_TARGETS BISBV_TARGETS
1389: WHERE BISBV_TARGETS.TARGET_LEVEL_ID = x_Target_Rec.Target_Level_ID
1390: AND BISBV_TARGETS.PLAN_ID = x_Target_Rec.Plan_ID
1391: AND NVL(BISBV_TARGETS.ORG_LEVEL_VALUE_ID, 'T')
1392: = DECODE( x_Target_Rec.Org_Level_Value_ID
1393: , FND_API.G_MISS_CHAR

Line 1390: AND BISBV_TARGETS.PLAN_ID = x_Target_Rec.Plan_ID

1386: SELECT TARGET_ID
1387: INTO x_Target_Rec.TARGET_ID
1388: FROM BISBV_TARGETS BISBV_TARGETS
1389: WHERE BISBV_TARGETS.TARGET_LEVEL_ID = x_Target_Rec.Target_Level_ID
1390: AND BISBV_TARGETS.PLAN_ID = x_Target_Rec.Plan_ID
1391: AND NVL(BISBV_TARGETS.ORG_LEVEL_VALUE_ID, 'T')
1392: = DECODE( x_Target_Rec.Org_Level_Value_ID
1393: , FND_API.G_MISS_CHAR
1394: , 'T'

Line 1391: AND NVL(BISBV_TARGETS.ORG_LEVEL_VALUE_ID, 'T')

1387: INTO x_Target_Rec.TARGET_ID
1388: FROM BISBV_TARGETS BISBV_TARGETS
1389: WHERE BISBV_TARGETS.TARGET_LEVEL_ID = x_Target_Rec.Target_Level_ID
1390: AND BISBV_TARGETS.PLAN_ID = x_Target_Rec.Plan_ID
1391: AND NVL(BISBV_TARGETS.ORG_LEVEL_VALUE_ID, 'T')
1392: = DECODE( x_Target_Rec.Org_Level_Value_ID
1393: , FND_API.G_MISS_CHAR
1394: , 'T'
1395: , NVL(x_Target_Rec.Org_Level_Value_ID, 'T')

Line 1397: AND NVL(BISBV_TARGETS.TIME_LEVEL_VALUE_ID, 'T')

1393: , FND_API.G_MISS_CHAR
1394: , 'T'
1395: , NVL(x_Target_Rec.Org_Level_Value_ID, 'T')
1396: )
1397: AND NVL(BISBV_TARGETS.TIME_LEVEL_VALUE_ID, 'T')
1398: = DECODE( x_Target_Rec.Time_Level_Value_ID
1399: , FND_API.G_MISS_CHAR
1400: , 'T'
1401: , NVL(x_Target_Rec.Time_Level_Value_ID, 'T')

Line 1403: AND NVL(BISBV_TARGETS.DIM1_LEVEL_VALUE_ID, 'T')

1399: , FND_API.G_MISS_CHAR
1400: , 'T'
1401: , NVL(x_Target_Rec.Time_Level_Value_ID, 'T')
1402: )
1403: AND NVL(BISBV_TARGETS.DIM1_LEVEL_VALUE_ID, 'T')
1404: = DECODE( x_Target_Rec.Dim1_Level_Value_ID
1405: , FND_API.G_MISS_CHAR
1406: , 'T'
1407: , NVL(x_Target_Rec.Dim1_Level_Value_ID, 'T')

Line 1409: AND NVL(BISBV_TARGETS.DIM2_LEVEL_VALUE_ID, 'T')

1405: , FND_API.G_MISS_CHAR
1406: , 'T'
1407: , NVL(x_Target_Rec.Dim1_Level_Value_ID, 'T')
1408: )
1409: AND NVL(BISBV_TARGETS.DIM2_LEVEL_VALUE_ID, 'T')
1410: = DECODE( x_Target_Rec.Dim2_Level_Value_ID
1411: , FND_API.G_MISS_CHAR
1412: , 'T'
1413: , NVL(x_Target_Rec.Dim2_Level_Value_ID, 'T')

Line 1415: AND NVL(BISBV_TARGETS.DIM3_LEVEL_VALUE_ID, 'T')

1411: , FND_API.G_MISS_CHAR
1412: , 'T'
1413: , NVL(x_Target_Rec.Dim2_Level_Value_ID, 'T')
1414: )
1415: AND NVL(BISBV_TARGETS.DIM3_LEVEL_VALUE_ID, 'T')
1416: = DECODE( x_Target_Rec.Dim3_Level_Value_ID
1417: , FND_API.G_MISS_CHAR
1418: , 'T'
1419: , NVL(x_Target_Rec.Dim3_Level_Value_ID, 'T')

Line 1421: AND NVL(BISBV_TARGETS.DIM4_LEVEL_VALUE_ID, 'T')

1417: , FND_API.G_MISS_CHAR
1418: , 'T'
1419: , NVL(x_Target_Rec.Dim3_Level_Value_ID, 'T')
1420: )
1421: AND NVL(BISBV_TARGETS.DIM4_LEVEL_VALUE_ID, 'T')
1422: = DECODE( x_Target_Rec.Dim4_Level_Value_ID
1423: , FND_API.G_MISS_CHAR
1424: , 'T'
1425: , NVL(x_Target_Rec.Dim4_Level_Value_ID, 'T')

Line 1427: AND NVL(BISBV_TARGETS.DIM5_LEVEL_VALUE_ID, 'T')

1423: , FND_API.G_MISS_CHAR
1424: , 'T'
1425: , NVL(x_Target_Rec.Dim4_Level_Value_ID, 'T')
1426: )
1427: AND NVL(BISBV_TARGETS.DIM5_LEVEL_VALUE_ID, 'T')
1428: = DECODE( x_Target_Rec.Dim5_Level_Value_ID
1429: , FND_API.G_MISS_CHAR
1430: , 'T'
1431: , NVL(x_Target_Rec.Dim5_Level_Value_ID, 'T')

Line 1433: AND NVL(BISBV_TARGETS.DIM6_LEVEL_VALUE_ID, 'T')

1429: , FND_API.G_MISS_CHAR
1430: , 'T'
1431: , NVL(x_Target_Rec.Dim5_Level_Value_ID, 'T')
1432: )
1433: AND NVL(BISBV_TARGETS.DIM6_LEVEL_VALUE_ID, 'T')
1434: = DECODE( x_Target_Rec.Dim6_Level_Value_ID
1435: , FND_API.G_MISS_CHAR
1436: , 'T'
1437: , NVL(x_Target_Rec.Dim6_Level_Value_ID, 'T')

Line 1439: AND NVL(BISBV_TARGETS.DIM7_LEVEL_VALUE_ID, 'T')

1435: , FND_API.G_MISS_CHAR
1436: , 'T'
1437: , NVL(x_Target_Rec.Dim6_Level_Value_ID, 'T')
1438: )
1439: AND NVL(BISBV_TARGETS.DIM7_LEVEL_VALUE_ID, 'T')
1440: = DECODE( x_Target_Rec.Dim7_Level_Value_ID
1441: , FND_API.G_MISS_CHAR
1442: , 'T'
1443: , NVL(x_Target_Rec.Dim7_Level_Value_ID, 'T')

Line 3188: from bisbv_targets

3184: dim4_level_value_id,
3185: dim5_level_value_id,
3186: dim6_level_value_id,
3187: dim7_level_value_id
3188: from bisbv_targets
3189: where target_id = p_target_id;
3190:
3191: BEGIN
3192: