DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on JTF_RS_GROUPS_TL

Line 1170: FROM jtf_rs_groups_tl gr

1166:
1167: -- :Sr_Group
1168: CURSOR Get_Group (v_owner_group_id NUMBER) IS
1169: SELECT gr.group_name
1170: FROM jtf_rs_groups_tl gr
1171: WHERE gr.group_id =v_owner_group_id
1172: AND gr.LANGUAGE = userenv('LANG');
1173:
1174: l_Sr_Group VARCHAR2(60);

Line 1516: FROM jtf_rs_groups_tl gr

1512: FROM cs_incident_urgencies_tl urgency
1513: WHERE urgency.incident_urgency_id = sr.incident_urgency_id
1514: AND urgency.language = userenv(''LANG'')) Incident_Urgency
1515: ,(SELECT gr.group_name
1516: FROM jtf_rs_groups_tl gr
1517: WHERE gr.group_id = sr.owner_group_id
1518: AND gr.LANGUAGE = userenv(''LANG''))Sr_Group
1519: ,(SELECT rs.resource_name
1520: FROM jtf_rs_resource_extns_tl rs