DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 1508: FROM jtf_rs_resource_extns rs

1504: -- swai: bug 7565999 - change cursor to take resorce group and resource id
1505: -- as params instead of relying on procedure parameters.
1506: CURSOR c1 (l_resource_group NUMBER, l_resource_id NUMBER) IS
1507: SELECT 'X'
1508: FROM jtf_rs_resource_extns rs
1509: WHERE l_resource_group IS NULL
1510: AND rs.resource_id = l_resource_id
1511: AND rs.category = 'EMPLOYEE'
1512: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(rs.start_date_active, SYSDATE))

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'