APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_GROUPS_B

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

746: end_date_active date;
747: l_object_version_num_grp number;
748:
749: --cursor to get details about group needs to end date
750: CURSOR term_grp_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE) IS
751: SELECT grp.group_id,
752: grp.group_number,
753: grp.object_version_number,
754: grp.start_date_active,

Line 756: FROM jtf_rs_groups_b grp

752: grp.group_number,
753: grp.object_version_number,
754: grp.start_date_active,
755: grp.end_date_active
756: FROM jtf_rs_groups_b grp
757: WHERE grp.group_id = c_group_id;
758:
759: term_grp_rec term_grp_cur%rowtype;
760:

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

758:
759: term_grp_rec term_grp_cur%rowtype;
760:
761: --cursor to get all active member roles
762: CURSOR group_mem_roles_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
763: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
764: SELECT rlt.role_relate_id,
765: rlt.start_date_active,
766: rlt.end_date_active,

Line 763: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS

759: term_grp_rec term_grp_cur%rowtype;
760:
761: --cursor to get all active member roles
762: CURSOR group_mem_roles_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
763: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
764: SELECT rlt.role_relate_id,
765: rlt.start_date_active,
766: rlt.end_date_active,
767: rlt.object_version_number

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

786:
787: group_mem_roles_rec group_mem_roles_cur%rowtype;
788:
789: --cursor to get all active parent or child group relations
790: CURSOR grp_relations_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
791: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
792: SELECT group_relate_id,
793: group_id,
794: related_group_id,

Line 791: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS

787: group_mem_roles_rec group_mem_roles_cur%rowtype;
788:
789: --cursor to get all active parent or child group relations
790: CURSOR grp_relations_cur(c_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
791: c_group_end_date JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE) IS
792: SELECT group_relate_id,
793: group_id,
794: related_group_id,
795: start_date_active,