APPS.CSD_REPAIRS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 1815: FROM jtf_rs_resource_extns rs

1811: -- swai: bug 7565999 - change cursor to take resorce group and resource id
1812: -- as params instead of relying on procedure parameters.
1813: CURSOR c1 (l_resource_group NUMBER, l_resource_id NUMBER) IS
1814: SELECT 'X'
1815: FROM jtf_rs_resource_extns rs
1816: WHERE l_resource_group IS NULL
1817: AND rs.resource_id = l_resource_id
1818: AND rs.category = 'EMPLOYEE'
1819: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(rs.start_date_active, SYSDATE))

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'