APPS.CSD_REPAIRS_PVT dependencies on JTF_RS_GROUP_USAGES
Line 1897: FROM jtf_rs_group_usages rs, jtf_Rs_groups_b rg
1893: IS
1894:
1895: CURSOR c1 IS
1896: SELECT 'X' 1897: FROM jtf_rs_group_usages rs, jtf_Rs_groups_b rg 1898: WHERE rs.group_id = p_resource_group
1899: AND rs.usage = 'REPAIR_ORGANIZATION'
1900: AND rs.group_id = rg.group_id
1901: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(rg.start_date_active, SYSDATE))