DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CS_SR_LOAD_BALANCE_WT

Line 922: FROM cs_sr_load_balance_wt

918: CURSOR c_load_wt(l_incident_type_id NUMBER,l_incident_severity_id NUMBER) IS
919: SELECT product_skill_wt,platform_skill_wt,prob_code_skill_wt,category_skill_wt,
920: last_login_time_wt,severity1_count_wt,severity2_count_wt,
921: severity3_count_wt,severity4_count_wt,time_zone_diff_wt
922: FROM cs_sr_load_balance_wt
923: WHERE incident_type_id = l_incident_type_id
924: AND incident_severity_id = l_incident_severity_id;
925:
926:

Line 1425: FROM cs_sr_load_balance_wt

1421: CURSOR c_load_wt(l_incident_type_id NUMBER,l_incident_severity_id NUMBER) IS
1422: SELECT product_skill_wt,platform_skill_wt,prob_code_skill_wt,category_skill_wt,
1423: last_login_time_wt,severity1_count_wt,severity2_count_wt,
1424: severity3_count_wt,severity4_count_wt,time_zone_diff_wt
1425: FROM cs_sr_load_balance_wt
1426: WHERE incident_type_id = l_incident_type_id
1427: AND incident_severity_id = l_incident_severity_id;
1428:
1429: -- Added nvl(rs.category_id,0) = nvl(l_cat_id,0) by pnkalari on 06/70/2002.