DBA Data[Home] [Help]

APPS.SR_UWQ_INTEG dependencies on JTF_RS_TEAMS_TL

Line 412: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl

408: l_value_flag varchar2(10);
409: l_node_query varchar2(10);
410:
411: cursor team_cursor is select distinct team_mem.team_id,team_tl.team_name
412: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl
413: where team_resource_id = p_resource_id
414: and team_mem.team_id = team_tl.team_id
415: and team_tl.language = userenv('LANG');
416:

Line 1930: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl

1926: l_value_flag varchar2(10);
1927: l_node_query varchar2(10);
1928:
1929: cursor team_cursor is select distinct team_mem.team_id,team_tl.team_name
1930: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl
1931: where team_resource_id = p_resource_id
1932: and team_mem.team_id = team_tl.team_id
1933: and team_tl.language = userenv('LANG');
1934:

Line 2455: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl

2451: l_value_flag varchar2(10);
2452: l_node_query varchar2(10);
2453:
2454: cursor team_cursor is select distinct team_mem.team_id,team_tl.team_name
2455: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl
2456: where team_resource_id = p_resource_id
2457: and team_mem.team_id = team_tl.team_id
2458: and team_tl.language = userenv('LANG');
2459:

Line 2980: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl

2976: l_value_flag varchar2(10);
2977: l_node_query varchar2(10);
2978:
2979: cursor team_cursor is select distinct team_mem.team_id,team_tl.team_name
2980: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl
2981: where team_resource_id = p_resource_id
2982: and team_mem.team_id = team_tl.team_id
2983: and team_tl.language = userenv('LANG');
2984: