141:
142:
143: cursor find_resource is
144: select a.resource_id resource_id, b.resource_type resource_type
145: from CSP_RS_RESOURCES_V b, jtf_rs_resource_extns a
146: where a.resource_id =b.resource_id
147: and a.user_id = FND_GLOBAL.USER_ID;
148:
149: r_find_resource find_resource%ROWTYPE;
654:
655:
656: cursor find_resource is
657: select a.resource_id resource_id, b.resource_type resource_type
658: from CSP_RS_RESOURCES_V b, jtf_rs_resource_extns a
659: where a.resource_id =b.resource_id
660: and a.user_id = FND_GLOBAL.USER_ID;
661:
662: r_find_resource find_resource%ROWTYPE;