APPS.BIX_ALERT dependencies on BIX_CALL_CENTER_V

Line 130: FROM bix_call_center_v

126: from bix_sum_grp_cls
127: group by to_char(hour,'MON-YYYY'), interaction_center_id;
128: CURSOR cr_center(p_center_id NUMBER) IS
129: SELECT call_center_name center_name
130: FROM bix_call_center_v
131: WHERE call_center_id = p_center_id;
132:
133: CURSOR cr_target(p_organization_id VARCHAR2,
134: p_center_id VARCHAR2, p_time VARCHAR2)

Line 413: FROM bix_call_center_v

409: group by to_char(hour,'MON-YYYY'), interaction_center_id;
410:
411: CURSOR cr_center(p_center_id NUMBER) IS
412: SELECT call_center_name center_name
413: FROM bix_call_center_v
414: WHERE call_center_id = p_center_id;
415:
416: CURSOR cr_target(p_organization_id VARCHAR2, p_center_id VARCHAR2,p_time VARCHAR2) IS
417: SELECT tv.target_level_short_name

Line 670: FROM bix_call_center_v

666: from bix_sum_grp_cls
667: group by to_char(hour,'MON-YYYY'), interaction_center_id;
668: CURSOR cr_center(p_center_id NUMBER) IS
669: SELECT call_center_name center_name
670: FROM bix_call_center_v
671: WHERE call_center_id = p_center_id;
672:
673: CURSOR cr_target(p_organization_id VARCHAR2, p_center_id VARCHAR2, p_time VARCHAR2) IS
674: SELECT tv.target_level_short_name

Line 974: FROM bix_call_center_v

970: from bix_sum_grp_cls
971: group by to_char(hour,'MON-YYYY'), interaction_center_id;
972: CURSOR cr_center(p_center_id NUMBER) IS
973: SELECT call_center_name center_name
974: FROM bix_call_center_v
975: WHERE call_center_id = p_center_id;
976:
977: CURSOR cr_target(p_organization_id VARCHAR2,
978: p_center_id VARCHAR2, p_time VARCHAR2)

Line 1282: FROM bix_call_center_v

1278: from bix_sum_grp_cls
1279: group by to_char(hour,'MON-YYYY'), interaction_center_id;
1280: CURSOR cr_center(p_center_id NUMBER) IS
1281: SELECT call_center_name center_name
1282: FROM bix_call_center_v
1283: WHERE call_center_id = p_center_id;
1284:
1285: CURSOR cr_target(p_organization_id VARCHAR2, p_center_id VARCHAR2, p_time VARCHAR2) IS
1286: SELECT tv.target_level_short_name

Line 1539: FROM bix_call_center_v

1535: from bix_sum_grp_cls
1536: group by to_char(hour,'MON-YYYY'), interaction_center_id;
1537: CURSOR cr_center(p_center_id NUMBER) IS
1538: SELECT call_center_name center_name
1539: FROM bix_call_center_v
1540: WHERE call_center_id = p_center_id;
1541:
1542: CURSOR cr_target(p_organization_id VARCHAR2,
1543: p_center_id VARCHAR2, p_time VARCHAR2)

Line 1802: FROM bix_call_center_v

1798: from bix_sum_grp_cls
1799: group by to_char(hour,'MON-YYYY'), interaction_center_id;
1800: CURSOR cr_center(p_center_id NUMBER) IS
1801: SELECT call_center_name center_name
1802: FROM bix_call_center_v
1803: WHERE call_center_id = p_center_id;
1804:
1805: CURSOR cr_target(p_organization_id VARCHAR2,
1806: p_center_id VARCHAR2, p_time VARCHAR2)

Line 2066: FROM bix_call_center_v

2062: from bix_sum_grp_cls
2063: group by to_char(hour,'MON-YYYY'), interaction_center_id;
2064: CURSOR cr_center(p_center_id NUMBER) IS
2065: SELECT call_center_name center_name
2066: FROM bix_call_center_v
2067: WHERE call_center_id = p_center_id;
2068: CURSOR cr_target(p_organization_id VARCHAR2,
2069: p_center_id VARCHAR2, p_time VARCHAR2)
2070: IS