APPS.POA_BIS_ALERTS dependencies on BISFV_TARGETS

Line 33: FROM BISFV_TARGETS tv

29: , tv.notify_resp2_id
30: , tv.notify_resp2_short_name
31: , tv.notify_resp3_id
32: , tv.notify_resp3_short_name
33: FROM BISFV_TARGETS tv
34: WHERE tv.target_level_short_name = p_target_level_short_name
35: AND tv.time_level_value_id = p_time_period
36: AND tv.org_level_value_id = TO_CHAR(p_org_id)
37: AND tv.plan_short_name = p_plan_short_name;

Line 78: FROM BISFV_TARGETS tv

74: p_target_orgs OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type) IS
75: l_index NUMBER := 0;
76: CURSOR cr_target_org IS
77: SELECT distinct(org_level_value_id) org_id
78: FROM BISFV_TARGETS tv
79: WHERE tv.target_level_short_name = p_target_level_short_name
80: AND tv.plan_short_name = p_plan_short_name;
81: BEGIN
82: