DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on JTF_RS_GROUPS_TL

Line 1099: FROM jtf_rs_groups_tl gr

1095:
1096: -- :Sr_Group
1097: CURSOR Get_Group (v_owner_group_id NUMBER) IS
1098: SELECT gr.group_name
1099: FROM jtf_rs_groups_tl gr
1100: WHERE gr.group_id =v_owner_group_id
1101: AND gr.LANGUAGE = userenv('LANG');
1102:
1103: l_Sr_Group VARCHAR2(60);

Line 1440: FROM jtf_rs_groups_tl gr

1436: FROM cs_incident_urgencies_tl urgency
1437: WHERE urgency.incident_urgency_id = sr.incident_urgency_id
1438: AND urgency.language = userenv(''LANG'')) Incident_Urgency
1439: ,(SELECT gr.group_name
1440: FROM jtf_rs_groups_tl gr
1441: WHERE gr.group_id = sr.owner_group_id
1442: AND gr.LANGUAGE = userenv(''LANG''))Sr_Group
1443: ,(SELECT rs.resource_name
1444: FROM jtf_rs_resource_extns_tl rs