APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_TEAMS_B

Line 369: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)

365: WHERE grp.group_id = l_group_id;
366:
367: group_dt_rec group_dt_cur%rowtype;
368:
369: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)
370: IS
371: SELECT tm.start_date_active,
372: tm.end_date_active
373: FROM jtf_rs_teams_b tm

Line 373: FROM jtf_rs_teams_b tm

369: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)
370: IS
371: SELECT tm.start_date_active,
372: tm.end_date_active
373: FROM jtf_rs_teams_b tm
374: WHERE tm.team_id = l_team_id;
375:
376: team_dt_rec team_dt_cur%rowtype;
377:

Line 384: FROM jtf_rs_teams_b tm,

380: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
381: IS
382: SELECT tm.start_date_active,
383: tm.end_date_active
384: FROM jtf_rs_teams_b tm,
385: jtf_rs_team_members mem
386: WHERE mem.team_member_id = ll_member_id
387: AND mem.team_id = tm.team_id;
388:

Line 1470: FROM jtf_rs_teams_b tm,

1466: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1467: IS
1468: SELECT tm.start_date_active,
1469: tm.end_date_active
1470: FROM jtf_rs_teams_b tm,
1471: jtf_rs_team_members mem
1472: WHERE mem.team_member_id = ll_member_id
1473: AND mem.team_id = tm.team_id
1474: AND nvl(mem.delete_flag, '0') <> 'Y';

Line 1497: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)

1493: WHERE grp.group_id = l_group_id;
1494:
1495: group_dt_rec group_dt_cur%rowtype;
1496:
1497: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)
1498: IS
1499: SELECT tm.start_date_active,
1500: tm.end_date_active
1501: FROM jtf_rs_teams_b tm

Line 1501: FROM jtf_rs_teams_b tm

1497: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)
1498: IS
1499: SELECT tm.start_date_active,
1500: tm.end_date_active
1501: FROM jtf_rs_teams_b tm
1502: WHERE tm.team_id = l_team_id;
1503:
1504: team_dt_rec team_dt_cur%rowtype;
1505: