DBA Data[Home] [Help]

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