APPS.HZ_DSS_GRANTS_PUB dependencies on HZ_DSS_GRANTS_V

Line 576: FROM hz_dss_grants_v grants,

572: ) IS
573:
574: CURSOR c_grant_exists IS
575: SELECT dsg.status
576: FROM hz_dss_grants_v grants,
577: hz_dss_groups_b dsg
578: WHERE dsg.dss_group_code = p_dss_group_code
579: AND grants.dss_group_code = p_dss_group_code
580: AND ROWNUM = 1;

Line 591: FROM hz_dss_grants_v

587: AND ins.object_id = obj.object_id;
588:
589: CURSOR c_grants IS
590: SELECT *
591: FROM hz_dss_grants_v
592: WHERE dss_group_code = p_dss_group_code;
593:
594: l_dsg_status VARCHAR2(1);
595: l_obj_name VARCHAR2(30);

Line 776: FROM hz_dss_grants_v grants, hz_dss_groups_b dsg

772: CURSOR c_grant IS
773: SELECT NVL(view_flag,'N'), NVL(insert_flag,'N'),
774: NVL(update_flag,'N'), NVL(delete_flag,'N'),
775: dsg.status
776: FROM hz_dss_grants_v grants, hz_dss_groups_b dsg
777: WHERE grants.dss_group_code = p_dss_group_code
778: AND dss_grantee_type = p_dss_grantee_type
779: AND (p_dss_grantee_type = 'GLOBAL' OR
780: p_dss_grantee_type <> 'GLOBAL' AND dss_grantee_key = p_dss_grantee_key)