[Home] [Help]
255: IS
256: CURSOR c0
257: IS
258: select 'y'
259: from fnd_objects FND , hz_dss_entities ENT
260: where FND.database_object_name = p_database_object_name and
261: FND.object_id = ENT.object_id and
262: ENT.group_assignment_level = 'ASSIGN';
263: l_yn VARCHAR2(1);
465: IS
466: CURSOR c0
467: IS
468: SELECT 'Y'
469: FROM fnd_objects
470: WHERE object_id = p_object_id;
471: l_yn VARCHAR2(1);
472: result VARCHAR2(1);
473: BEGIN