APPS.BIX_ALERT dependencies on BISFV_TARGETS

Line 157: FROM BISFV_TARGETS tv

153: , tv.notify_resp2_short_name
154: , tv.notify_resp3_id
155: , tv.notify_resp3_short_name
156: , tv.dim1_level_value_id
157: FROM BISFV_TARGETS tv
158: WHERE tv.target_level_short_name = p_target_level_short_name
159: AND tv.time_level_value_id like '%' || p_time || '%'
160: AND tv.org_level_value_id = p_organization_id
161: AND tv.dim1_level_value_name = p_center_id;

Line 438: FROM BISFV_TARGETS tv

434: , tv.notify_resp2_short_name
435: , tv.notify_resp3_id
436: , tv.notify_resp3_short_name
437: , tv.dim1_level_value_id
438: FROM BISFV_TARGETS tv
439: WHERE tv.target_level_short_name = p_target_level_short_name
440: AND tv.time_level_value_id like '%' || p_time || '%'
441: AND tv.org_level_value_id = p_organization_id
442: AND tv.dim1_level_value_name = p_center_id;

Line 695: FROM BISFV_TARGETS tv

691: , tv.notify_resp2_short_name
692: , tv.notify_resp3_id
693: , tv.notify_resp3_short_name
694: , tv.dim1_level_value_id
695: FROM BISFV_TARGETS tv
696: WHERE tv.target_level_short_name = p_target_level_short_name
697: AND tv.time_level_value_id like '%' || p_time || '%'
698: AND tv.org_level_value_id = p_organization_id
699: AND tv.dim1_level_value_name = p_center_id;

Line 1001: FROM BISFV_TARGETS tv

997: , tv.notify_resp2_short_name
998: , tv.notify_resp3_id
999: , tv.notify_resp3_short_name
1000: , tv.dim1_level_value_id
1001: FROM BISFV_TARGETS tv
1002: WHERE tv.target_level_short_name = p_target_level_short_name
1003: AND tv.time_level_value_id like '%' || p_time || '%'
1004: AND tv.org_level_value_id = p_organization_id
1005: AND tv.dim1_level_value_name = p_center_id;

Line 1307: FROM BISFV_TARGETS tv

1303: , tv.notify_resp2_short_name
1304: , tv.notify_resp3_id
1305: , tv.notify_resp3_short_name
1306: , tv.dim1_level_value_id
1307: FROM BISFV_TARGETS tv
1308: WHERE tv.target_level_short_name = p_target_level_short_name
1309: AND tv.time_level_value_id like '%' || p_time || '%'
1310: AND tv.org_level_value_id = p_organization_id
1311: AND tv.dim1_level_value_name = p_center_id;

Line 1566: FROM BISFV_TARGETS tv

1562: , tv.notify_resp2_short_name
1563: , tv.notify_resp3_id
1564: , tv.notify_resp3_short_name
1565: , tv.dim1_level_value_id
1566: FROM BISFV_TARGETS tv
1567: WHERE tv.target_level_short_name = p_target_level_short_name
1568: AND tv.time_level_value_id like '%' || p_time || '%'
1569: AND tv.org_level_value_id = p_organization_id
1570: AND tv.dim1_level_value_name = p_center_id;

Line 1829: FROM BISFV_TARGETS tv

1825: , tv.notify_resp2_short_name
1826: , tv.notify_resp3_id
1827: , tv.notify_resp3_short_name
1828: , tv.dim1_level_value_id
1829: FROM BISFV_TARGETS tv
1830: WHERE tv.target_level_short_name = p_target_level_short_name
1831: AND tv.time_level_value_id like '%' || p_time || '%'
1832: AND tv.org_level_value_id = p_organization_id
1833: AND tv.dim1_level_value_name = p_center_id;

Line 2092: FROM BISFV_TARGETS tv

2088: , tv.notify_resp2_short_name
2089: , tv.notify_resp3_id
2090: , tv.notify_resp3_short_name
2091: , tv.dim1_level_value_id
2092: FROM BISFV_TARGETS tv
2093: WHERE tv.target_level_short_name = p_target_level_short_name
2094: AND tv.time_level_value_id like '%' || p_time || '%'
2095: AND tv.org_level_value_id = p_organization_id
2096: AND tv.dim1_level_value_name = p_center_id;