APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_ROLES_B

Line 338: jtf_rs_roles_b r,

334: FROM jtf_rs_groups_b g,
335: jtf_rs_group_usages u,
336: jtf_rs_group_members m,
337: jtf_rs_role_relations rr,
338: jtf_rs_roles_b r,
339: jtf_rs_resource_extns res
340: WHERE g.group_id = l_resource_group_id
341: AND sysdate between nvl(g.start_date_active,sysdate) and
342: nvl(g.end_date_active,sysdate)

Line 387: jtf_rs_roles_b tr,

383: FROM jtf_rs_team_members tm,
384: jtf_rs_teams_b t,
385: jtf_rs_team_usages tu,
386: jtf_rs_role_relations trr,
387: jtf_rs_roles_b tr,
388: jtf_rs_resource_extns tres,
389: (
390: SELECT m.group_id group_id,
391: m.resource_id resource_id

Line 396: jtf_rs_roles_b r,

392: FROM jtf_rs_group_members m,
393: jtf_rs_groups_b g,
394: jtf_rs_group_usages u,
395: jtf_rs_role_relations rr,
396: jtf_rs_roles_b r,
397: jtf_rs_resource_extns res
398: WHERE m.group_id = g.group_id
399: AND sysdate BETWEEN nvl(g.start_date_active,sysdate)
400: AND nvl(g.end_date_active,sysdate)

Line 446: jtf_rs_roles_b r,

442: FROM jtf_rs_group_members m,
443: jtf_rs_groups_b g,
444: jtf_rs_group_usages u,
445: jtf_rs_role_relations rr,
446: jtf_rs_roles_b r,
447: jtf_rs_resource_extns res,
448: (
449: SELECT tm.team_resource_id group_id, t.team_id team_id
450: FROM jtf_rs_team_members tm,

Line 454: jtf_rs_roles_b tr,

450: FROM jtf_rs_team_members tm,
451: jtf_rs_teams_b t,
452: jtf_rs_team_usages tu,
453: jtf_rs_role_relations trr,
454: jtf_rs_roles_b tr,
455: jtf_rs_resource_extns tres
456: WHERE tm.team_id = t.team_id
457: AND sysdate between nvl(t.start_date_active,sysdate)
458: and nvl(t.end_date_active,sysdate)

Line 1526: jtf_rs_roles_b r

1522: CURSOR l_get_res_category(cv_resource_id NUMBER) IS
1523: SELECT category
1524: FROM jtf_rs_resource_extns res,
1525: jtf_rs_role_relations rr,
1526: jtf_rs_roles_b r
1527: WHERE res.resource_id = cv_resource_id
1528: AND res.resource_id = rr.role_resource_id
1529: AND rr.role_resource_type ='RS_INDIVIDUAL'
1530: AND NVL(rr.delete_flag,'N') <> 'Y'