APPS.CSD_REPAIRS_PVT dependencies on JTF_RS_GROUPS_B

Line 1824: FROM jtf_rs_group_members rm, jtf_rs_resource_extns rs,jtf_rs_groups_b rg

1820: AND TRUNC(NVL(rs.end_date_active, SYSDATE))
1821: UNION
1822:
1823: SELECT 'X'
1824: FROM jtf_rs_group_members rm, jtf_rs_resource_extns rs,jtf_rs_groups_b rg
1825: WHERE l_resource_group IS NOT NULL
1826: AND rm.resource_id = l_resource_id
1827: AND rm.group_id = l_resource_group
1828: AND rm.delete_flag <> 'Y'

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))