DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_TEAM_USAGES

Line 1006: jtf_rs_team_usages tu,

1002: SELECT t.start_date_active, t.end_date_active, rr.role_id,
1003: sr.salesrep_id, tm.team_id, t.team_name
1004: from jtf_rs_team_members tm,
1005: jtf_rs_salesreps sr,
1006: jtf_rs_team_usages tu,
1007: jtf_rs_role_relations rr,
1008: jtf_rs_roles_b rb,
1009: jtf_rs_teams_vl t
1010: where rr.role_relate_id = p_role_relate_id

Line 1864: jtf_rs_team_usages tu,

1860: SELECT t.start_date_active, t.end_date_active, rr.role_id,
1861: sr.salesrep_id, tm.team_id, t.team_name
1862: from jtf_rs_team_members tm,
1863: jtf_rs_salesreps sr,
1864: jtf_rs_team_usages tu,
1865: jtf_rs_role_relations rr,
1866: jtf_rs_roles_b rb,
1867: jtf_rs_teams_vl t
1868: where rr.role_relate_id = p_role_relate_id

Line 2206: jtf_rs_team_usages tu,

2202: CURSOR team_member_role_relate IS
2203: SELECT rr.start_date_active, rr.end_date_active, tm.team_id, t.team_name
2204: from jtf_rs_team_members tm,
2205: jtf_rs_salesreps sr,
2206: jtf_rs_team_usages tu,
2207: jtf_rs_role_relations rr,
2208: jtf_rs_roles_b rb,
2209: jtf_rs_teams_vl t
2210: where rr.role_relate_id = p_role_relate_id