DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_SRP_COMP_TEAMS_V

Line 1051: cn_srp_comp_teams_v srt,

1047: FROM jtf_rs_group_usages u,
1048: jtf_rs_group_mbr_role_vl r,
1049: cn_rs_salesreps s, -- single-org view
1050: jtf_rs_roles_b ro,
1051: cn_srp_comp_teams_v srt,
1052: cn_comp_teams ct
1053: WHERE r.role_relate_id = p_role_relate_id
1054: AND s.salesrep_id = p_salesrep_id -- safe since single-org context
1055: AND u.group_id = r.group_id

Line 1467: cn_srp_comp_teams_v srt,

1463: FROM jtf_rs_group_usages u,
1464: jtf_rs_group_mbr_role_vl r,
1465: cn_rs_salesreps s,
1466: jtf_rs_roles_b ro,
1467: cn_srp_comp_teams_v srt,
1468: cn_comp_teams ct
1469: WHERE r.role_relate_id = p_role_relate_id
1470: AND s.salesrep_id = p_salesrep_id
1471: AND u.group_id = r.group_id

Line 1905: cn_srp_comp_teams_v srt,

1901: FROM jtf_rs_group_usages u,
1902: jtf_rs_group_mbr_role_vl r,
1903: cn_rs_salesreps s,
1904: jtf_rs_roles_b ro,
1905: cn_srp_comp_teams_v srt,
1906: cn_comp_teams ct
1907: WHERE r.role_relate_id = p_role_relate_id
1908: AND s.salesrep_id = p_salesrep_id
1909: AND u.group_id = r.group_id

Line 2251: cn_srp_comp_teams_v srt,

2247: FROM jtf_rs_group_usages u,
2248: jtf_rs_group_mbr_role_vl r,
2249: cn_rs_salesreps s,
2250: jtf_rs_roles_b ro,
2251: cn_srp_comp_teams_v srt,
2252: cn_comp_teams ct
2253: WHERE r.role_relate_id = p_role_relate_id
2254: AND s.salesrep_id = p_salesrep_id
2255: AND u.group_id = r.group_id