APPS.JTF_RS_GRP_MEMBERSHIP_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 55: from jtf_rs_role_relations

51:
52: cursor chk_role_relate(l_role_id number, l_resource_id number)
53: is
54: select role_relate_id,start_date_active,end_date_active,object_version_number
55: from jtf_rs_role_relations
56: where role_id = l_role_id
57: and role_resource_id = l_resource_id
58: and role_resource_type = 'RS_INDIVIDUAL'
59: and nvl(delete_flag, 'N') <> 'Y'

Line 455: from jtf_rs_role_relations

451:
452: cursor chk_role_relate(l_role_id number, l_resource_id number)
453: is
454: select role_relate_id,start_date_active,end_date_active,object_version_number
455: from jtf_rs_role_relations
456: where role_id = l_role_id
457: and role_resource_id = l_resource_id
458: and role_resource_type = 'RS_INDIVIDUAL'
459: and nvl(delete_flag, 'N') <> 'Y'

Line 723: from jtf_rs_role_relations

719:
720: cursor group_member_exists(l_group_member_id number)
721: is
722: select role_relate_id
723: from jtf_rs_role_relations
724: where role_resource_id = l_group_member_id
725: and role_resource_type = 'RS_GROUP_MEMBER'
726: and nvl(delete_flag, 'N') <> 'Y';
727:

Line 728: l_role_relete_id jtf_rs_role_relations.role_relate_id%type;

724: where role_resource_id = l_group_member_id
725: and role_resource_type = 'RS_GROUP_MEMBER'
726: and nvl(delete_flag, 'N') <> 'Y';
727:
728: l_role_relete_id jtf_rs_role_relations.role_relate_id%type;
729:
730: /* Cursor Variables to get object_version_number for group member */
731:
732: cursor get_obj_ver_num(l_group_member_id number)

Line 738: l_object_version_num jtf_rs_role_relations.object_version_number%type;

734: select object_version_number
735: from jtf_rs_group_members
736: where group_member_id = l_group_member_id;
737:
738: l_object_version_num jtf_rs_role_relations.object_version_number%type;
739:
740: BEGIN
741:
742: x_return_status := fnd_api.g_ret_sts_success;