APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 339: jtf_rs_resource_extns res

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)
343: AND u.group_id = g.group_id

Line 388: jtf_rs_resource_extns tres,

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
392: FROM jtf_rs_group_members m,

Line 397: jtf_rs_resource_extns res

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)
401: AND u.group_id = g.group_id

Line 447: jtf_rs_resource_extns res,

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,
451: jtf_rs_teams_b t,

Line 455: jtf_rs_resource_extns tres

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)
459: AND tu.team_id = t.team_id

Line 674: FROM jtf_rs_resource_extns RES,

670:
671: /* PINAGARA: Introduced jtf_rs_groups_b table as bug fix for 4869726 */
672: CURSOR l_res_is_vendor_CM_csr(cv_resource_id NUMBER) IS
673: SELECT 'Y'
674: FROM jtf_rs_resource_extns RES,
675: jtf_rs_group_members GRPMEM,
676: jtf_rs_group_usages GRPUSG,
677: jtf_rs_role_relations ROLRELAT ,
678: jtf_rs_roles_vl ROLE,

Line 768: jtf_rs_resource_extns RES

764: FROM
765: pv_partner_profiles PROFILE,
766: hz_relationships HZPR_PART_CONT ,
767: hz_parties CONTACT ,
768: jtf_rs_resource_extns RES
769: WHERE
770: PROFILE.partner_id = cv_partner_id
771: AND PROFILE.partner_party_id = HZPR_PART_CONT.object_id
772: AND HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'

Line 889: FROM jtf_rs_resource_extns RES

885: AND resource_id = cv_resource_id;
886:
887: CURSOR l_VAD_Org_csr(cv_resource_id IN NUMBER) IS
888: SELECT source_org_id
889: FROM jtf_rs_resource_extns RES
890: WHERE resource_id = cv_resource_id;
891:
892: BEGIN
893:

Line 1084: FROM jtf_rs_resource_extns

1080: -- a CHANNEL_MANAGER or 'CHANNEL_REP' role.
1081:
1082: CURSOR l_get_resource_id_csr (cv_user_id NUMBER) IS
1083: SELECT resource_id
1084: FROM jtf_rs_resource_extns
1085: WHERE user_id = cv_user_id
1086: AND sysdate between nvl(start_date_active,sysdate) and
1087: nvl(end_date_active,sysdate);
1088:

Line 1524: FROM jtf_rs_resource_extns res,

1520:
1521: -- Get the Individual resource information
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

Line 4652: jtf_rs_resource_extns RES ,

4648: RES.resource_id
4649: FROM
4650: hz_relationships HZPR_PART_CONT ,
4651: hz_parties CONTACT ,
4652: jtf_rs_resource_extns RES ,
4653: jtf_rs_group_members GRPMEM,
4654: jtf_rs_group_usages GRPUSG,
4655: jtf_rs_role_relations ROLRELAT ,
4656: jtf_rs_roles_vl ROLE