APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_GROUPS_B

Line 762: CURSOR term_grp_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE) IS

758: end_date_active date;
759: l_object_version_num_grp number;
760:
761: --cursor to get details about group needs to end date
762: CURSOR term_grp_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE) IS
763: SELECT grp.group_id,
764: grp.group_number,
765: grp.object_version_number,
766: grp.start_date_active,

Line 768: FROM jtf_rs_groups_b grp

764: grp.group_number,
765: grp.object_version_number,
766: grp.start_date_active,
767: grp.end_date_active
768: FROM jtf_rs_groups_b grp
769: WHERE grp.group_id = c_group_id;
770:
771: term_grp_rec term_grp_cur%rowtype;
772:

Line 774: CURSOR group_mem_roles_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

770:
771: term_grp_rec term_grp_cur%rowtype;
772:
773: --cursor to get all active member roles
774: CURSOR group_mem_roles_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
775: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
776: SELECT rlt.role_relate_id,
777: rlt.start_date_active,
778: rlt.end_date_active,

Line 775: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS

771: term_grp_rec term_grp_cur%rowtype;
772:
773: --cursor to get all active member roles
774: CURSOR group_mem_roles_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
775: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
776: SELECT rlt.role_relate_id,
777: rlt.start_date_active,
778: rlt.end_date_active,
779: rlt.object_version_number

Line 802: CURSOR grp_relations_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

798:
799: group_mem_roles_rec group_mem_roles_cur%rowtype;
800:
801: --cursor to get all active parent or child group relations
802: CURSOR grp_relations_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
803: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
804: SELECT group_relate_id,
805: group_id,
806: related_group_id,

Line 803: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS

799: group_mem_roles_rec group_mem_roles_cur%rowtype;
800:
801: --cursor to get all active parent or child group relations
802: CURSOR grp_relations_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
803: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
804: SELECT group_relate_id,
805: group_id,
806: related_group_id,
807: start_date_active,