APPS.CSM_UTIL_PKG dependencies on JTF_RS_GROUPS_TL

Line 1888: JTF_RS_GROUPS_TL TL

1884:
1885: CURSOR c_grp_name(b_grp_id NUMBER,b_lang VARCHAR2) IS
1886: SELECT TL.GROUP_NAME
1887: FROM JTF_RS_GROUPS_B B,
1888: JTF_RS_GROUPS_TL TL
1889: WHERE B.GROUP_ID = b_grp_id
1890: AND B.GROUP_ID = TL.GROUP_ID
1891: AND TL.LANGUAGE=b_lang;
1892:

Line 2103: FROM jtf_rs_groups_tl

2099: IS
2100: CURSOR c_get_group_name(b_group_id NUMBER, b_language VARCHAR2)
2101: IS
2102: SELECT GROUP_NAME--group_desc is a nullable column hence group_name is selected
2103: FROM jtf_rs_groups_tl
2104: WHERE GROUP_ID = b_group_id
2105: AND LANGUAGE = b_language;
2106:
2107: l_group_name VARCHAR2(60) := NULL;