APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_TEAMS_B

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

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

Line 375: FROM jtf_rs_teams_b tm

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

Line 386: FROM jtf_rs_teams_b tm,

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

Line 1484: FROM jtf_rs_teams_b tm,

1480: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1481: IS
1482: SELECT tm.start_date_active,
1483: tm.end_date_active
1484: FROM jtf_rs_teams_b tm,
1485: jtf_rs_team_members mem
1486: WHERE mem.team_member_id = ll_member_id
1487: AND mem.team_id = tm.team_id
1488: AND nvl(mem.delete_flag, '0') <> 'Y';

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

1507: WHERE grp.group_id = l_group_id;
1508:
1509: group_dt_rec group_dt_cur%rowtype;
1510:
1511: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)
1512: IS
1513: SELECT tm.start_date_active,
1514: tm.end_date_active
1515: FROM jtf_rs_teams_b tm

Line 1515: FROM jtf_rs_teams_b tm

1511: CURSOR team_dt_cur(l_team_id JTF_RS_TEAMS_B.TEAM_ID%TYPE)
1512: IS
1513: SELECT tm.start_date_active,
1514: tm.end_date_active
1515: FROM jtf_rs_teams_b tm
1516: WHERE tm.team_id = l_team_id;
1517:
1518: team_dt_rec team_dt_cur%rowtype;
1519: