APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_GROUPS_B

Line 352: FROM jtf_rs_groups_b grp,

348: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
349: IS
350: SELECT grp.start_date_active,
351: grp.end_date_active
352: FROM jtf_rs_groups_b grp,
353: jtf_rs_group_members mem
354: WHERE mem.group_member_id = ll_member_id
355: AND mem.group_id = grp.group_id;
356:

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

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

Line 364: FROM jtf_rs_groups_b grp

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

Line 408: FROM jtf_rs_groups_b G1,

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

Line 409: jtf_rs_groups_b G2,

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

Line 1457: FROM jtf_rs_groups_b grp,

1453: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1454: IS
1455: SELECT grp.start_date_active,
1456: grp.end_date_active
1457: FROM jtf_rs_groups_b grp,
1458: jtf_rs_group_members mem
1459: WHERE mem.group_member_id = ll_member_id
1460: AND mem.group_id = grp.group_id
1461: AND nvl(mem.delete_flag, '0') <> 'Y';

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

1484:
1485: rsc_rec rsc_cur%rowtype;
1486:
1487:
1488: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
1489: IS
1490: SELECT grp.start_date_active,
1491: grp.end_date_active
1492: FROM jtf_rs_groups_b grp

Line 1492: FROM jtf_rs_groups_b grp

1488: CURSOR group_dt_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
1489: IS
1490: SELECT grp.start_date_active,
1491: grp.end_date_active
1492: FROM jtf_rs_groups_b grp
1493: WHERE grp.group_id = l_group_id;
1494:
1495: group_dt_rec group_dt_cur%rowtype;
1496:

Line 1512: FROM jtf_rs_groups_b G1,

1508: l_start_date_active DATE,
1509: L_end_date_active DATE)
1510: IS
1511: SELECT 'X'
1512: FROM jtf_rs_groups_b G1,
1513: jtf_rs_groups_b G2,
1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,

Line 1513: jtf_rs_groups_b G2,

1509: L_end_date_active DATE)
1510: IS
1511: SELECT 'X'
1512: FROM jtf_rs_groups_b G1,
1513: jtf_rs_groups_b G2,
1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,