DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_TEAMS_VL

Line 1009: jtf_rs_teams_vl t

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
1011: and rr.role_resource_type(+) = 'RS_TEAM_MEMBER'
1012: and tm.resource_type = 'INDIVIDUAL'
1013: and tm.delete_flag = 'N'

Line 1867: jtf_rs_teams_vl t

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
1869: and rr.role_resource_type(+) = 'RS_TEAM_MEMBER'
1870: and tm.resource_type = 'INDIVIDUAL'
1871: and tm.delete_flag = 'N'

Line 2209: jtf_rs_teams_vl t

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
2211: and rr.role_resource_type(+) = 'RS_TEAM_MEMBER'
2212: and tm.resource_type = 'INDIVIDUAL'
2213: and tm.delete_flag = 'N'