APPS.HZ_DSS_GRANTS_PUB dependencies on HZ_DSS_GROUPS_B

Line 423: FROM hz_dss_groups_b

419: G_PROCEDURE_NAME VARCHAR2(30) := 'CREATE_GRANT';
420:
421: CURSOR c_dss_groups IS
422: SELECT status
423: FROM hz_dss_groups_b
424: WHERE dss_group_code = p_dss_group_code;
425:
426: l_dsg_status VARCHAR2(1);
427: l_end_date DATE;

Line 577: hz_dss_groups_b dsg

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;
581:

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)

Line 1155: FROM hz_dss_groups_b

1151: ) IS
1152:
1153: CURSOR c_dss_groups IS
1154: SELECT status
1155: FROM hz_dss_groups_b
1156: WHERE dss_group_code = p_dss_group_code;
1157:
1158: CURSOR c_grants IS
1159: SELECT grants.grant_guid,