APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on CS_SR_LOAD_BALANCE_WT

Line 1078: from cs_sr_load_balance_wt

1074:
1075: --Added in 11.5.9
1076: CURSOR c_load_wt(l_incident_type_id NUMBER,l_incident_severity_id NUMBER) IS
1077: select product_skill_wt,prob_code_skill_wt, category_skill_wt
1078: from cs_sr_load_balance_wt
1079: where incident_type_id = l_incident_type_id
1080: and incident_severity_id = l_incident_severity_id;
1081:
1082: -- Added in 11.5.9. Fetch phone area code for the customer.

Line 1497: FROM cs_sr_load_balance_wt

1493: CURSOR c_load_wt(l_incident_type_id NUMBER,l_incident_severity_id NUMBER) IS
1494: SELECT product_skill_wt,platform_skill_wt,prob_code_skill_wt, category_skill_wt,
1495: last_login_time_wt,severity1_count_wt,severity2_count_wt,
1496: severity3_count_wt,severity4_count_wt,time_zone_diff_wt
1497: FROM cs_sr_load_balance_wt
1498: WHERE incident_type_id = l_incident_type_id
1499: AND incident_severity_id = l_incident_severity_id;
1500:
1501: CURSOR C_PROD_SKILL(l_prod_id NUMBER,l_prod_org_id NUMBER,l_resource_id NUMBER) IS