APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_GROUPS_B

Line 353: FROM jtf_rs_groups_b grp,

349: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
350: IS
351: SELECT grp.start_date_active,
352: grp.end_date_active
353: FROM jtf_rs_groups_b grp,
354: jtf_rs_group_members mem
355: WHERE mem.group_member_id = ll_member_id
356: AND mem.group_id = grp.group_id
357: AND nvl(mem.delete_flag, '0') <> 'Y';

Line 362: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

358:
359: group_rec group_cur%rowtype;
360:
361: --
362: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
363: IS
364: SELECT grp.start_date_active,
365: grp.end_date_active
366: FROM jtf_rs_groups_b grp

Line 366: FROM jtf_rs_groups_b grp

362: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
363: IS
364: SELECT grp.start_date_active,
365: grp.end_date_active
366: FROM jtf_rs_groups_b grp
367: WHERE grp.group_id = l_group_id;
368:
369: group_dt_rec group_dt_cur%rowtype;
370:

Line 410: FROM jtf_rs_groups_b G1,

406: l_start_date_active DATE,
407: L_end_date_active DATE)
408: IS
409: SELECT 'X'
410: FROM jtf_rs_groups_b G1,
411: jtf_rs_groups_b G2,
412: jtf_rs_group_members GM1,
413: jtf_rs_group_members GM2,
414: jtf_rs_group_usages GU1,

Line 411: jtf_rs_groups_b G2,

407: L_end_date_active DATE)
408: IS
409: SELECT 'X'
410: FROM jtf_rs_groups_b G1,
411: jtf_rs_groups_b G2,
412: jtf_rs_group_members GM1,
413: jtf_rs_group_members GM2,
414: jtf_rs_group_usages GU1,
415: jtf_rs_group_usages GU2,

Line 1471: FROM jtf_rs_groups_b grp,

1467: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1468: IS
1469: SELECT grp.start_date_active,
1470: grp.end_date_active
1471: FROM jtf_rs_groups_b grp,
1472: jtf_rs_group_members mem
1473: WHERE mem.group_member_id = ll_member_id
1474: AND mem.group_id = grp.group_id
1475: AND nvl(mem.delete_flag, '0') <> 'Y';

Line 1502: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

1498:
1499: rsc_rec rsc_cur%rowtype;
1500:
1501:
1502: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
1503: IS
1504: SELECT grp.start_date_active,
1505: grp.end_date_active
1506: FROM jtf_rs_groups_b grp

Line 1506: FROM jtf_rs_groups_b grp

1502: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
1503: IS
1504: SELECT grp.start_date_active,
1505: grp.end_date_active
1506: FROM jtf_rs_groups_b grp
1507: WHERE grp.group_id = l_group_id;
1508:
1509: group_dt_rec group_dt_cur%rowtype;
1510:

Line 1526: FROM jtf_rs_groups_b G1,

1522: l_start_date_active DATE,
1523: L_end_date_active DATE)
1524: IS
1525: SELECT 'X'
1526: FROM jtf_rs_groups_b G1,
1527: jtf_rs_groups_b G2,
1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,

Line 1527: jtf_rs_groups_b G2,

1523: L_end_date_active DATE)
1524: IS
1525: SELECT 'X'
1526: FROM jtf_rs_groups_b G1,
1527: jtf_rs_groups_b G2,
1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,