APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_TEAM_MEMBERS

Line 966: from jtf_rs_team_members tm, jtf_rs_salesreps s

962: and delete_flag = 'N'
963: AND p_role_resource_type = 'RS_GROUP_MEMBER'
964: UNION ALL
965: select salesrep_id, org_id
966: from jtf_rs_team_members tm, jtf_rs_salesreps s
967: where tm.team_member_id = p_role_resource_id
968: and tm.team_resource_id = s.resource_id
969: and resource_type = 'INDIVIDUAL'
970: and delete_flag = 'N'

Line 1004: from jtf_rs_team_members tm,

1000: -- run in single-org context
1001: CURSOR team_member_role_relate IS
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,

Line 1445: from jtf_rs_team_members tm, jtf_rs_salesreps s

1441: and delete_flag = 'N'
1442: AND l_role_resource_type = 'RS_GROUP_MEMBER'
1443: UNION ALL
1444: select salesrep_id, org_id
1445: from jtf_rs_team_members tm, jtf_rs_salesreps s
1446: where tm.team_member_id = l_role_resource_id
1447: and tm.team_resource_id = s.resource_id
1448: and resource_type = 'INDIVIDUAL'
1449: and delete_flag = 'N'

Line 1851: from jtf_rs_team_members tm, jtf_rs_salesreps s

1847: and delete_flag = 'N'
1848: AND l_role_resource_type = 'RS_GROUP_MEMBER'
1849: UNION ALL
1850: select salesrep_id, org_id
1851: from jtf_rs_team_members tm, jtf_rs_salesreps s
1852: where tm.team_member_id = l_role_resource_id
1853: and tm.team_resource_id = s.resource_id
1854: and resource_type = 'INDIVIDUAL'
1855: and delete_flag = 'N'

Line 1862: from jtf_rs_team_members tm,

1858: -- run in single-org context
1859: CURSOR team_member_role_relate IS
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,

Line 2194: from jtf_rs_team_members tm, jtf_rs_salesreps s

2190: and delete_flag = 'N'
2191: AND l_role_resource_type = 'RS_GROUP_MEMBER'
2192: UNION ALL
2193: select salesrep_id, org_id
2194: from jtf_rs_team_members tm, jtf_rs_salesreps s
2195: where tm.team_member_id = l_role_resource_id
2196: and tm.team_resource_id = s.resource_id
2197: and resource_type = 'INDIVIDUAL'
2198: and delete_flag = 'N'

Line 2204: from jtf_rs_team_members tm,

2200:
2201: -- run in single-org context
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,