APPS.CSD_REPAIRS_PVT dependencies on JTF_RS_GROUPS_B

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

1513: AND TRUNC(NVL(rs.end_date_active, SYSDATE))
1514: UNION
1515:
1516: SELECT 'X'
1517: FROM jtf_rs_group_members rm, jtf_rs_resource_extns rs,jtf_rs_groups_b rg
1518: WHERE l_resource_group IS NOT NULL
1519: AND rm.resource_id = l_resource_id
1520: AND rm.group_id = l_resource_group
1521: AND rm.delete_flag <> 'Y'

Line 1590: FROM jtf_rs_group_usages rs, jtf_Rs_groups_b rg

1586: IS
1587:
1588: CURSOR c1 IS
1589: SELECT 'X'
1590: FROM jtf_rs_group_usages rs, jtf_Rs_groups_b rg
1591: WHERE rs.group_id = p_resource_group
1592: AND rs.usage = 'REPAIR_ORGANIZATION'
1593: AND rs.group_id = rg.group_id
1594: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(rg.start_date_active, SYSDATE))