DBA Data[Home] [Help]

APPS.JTF_ESCWFACTIVITY_PVT dependencies on JTF_RS_GROUP_MBR_ROLE_VL

Line 688: CURSOR c_query_group(b_group_id JTF_RS_GROUP_MBR_ROLE_VL.GROUP_ID%TYPE,

684:
685: -------------------------------------------------------------------------
686: -- Cursor for Resource Group query
687: -------------------------------------------------------------------------
688: CURSOR c_query_group(b_group_id JTF_RS_GROUP_MBR_ROLE_VL.GROUP_ID%TYPE,
689: b_now DATE)
690: IS SELECT role.resource_id
691: FROM JTF_RS_GROUP_MBR_ROLE_VL role,
692: JTF_RS_GROUP_MEMBERS_VL mem

Line 691: FROM JTF_RS_GROUP_MBR_ROLE_VL role,

687: -------------------------------------------------------------------------
688: CURSOR c_query_group(b_group_id JTF_RS_GROUP_MBR_ROLE_VL.GROUP_ID%TYPE,
689: b_now DATE)
690: IS SELECT role.resource_id
691: FROM JTF_RS_GROUP_MBR_ROLE_VL role,
692: JTF_RS_GROUP_MEMBERS_VL mem
693: WHERE role.group_id = b_group_id
694: AND mem.group_id = b_group_id
695: AND role.group_member_id = mem.group_member_id