DBA Data[Home] [Help]

APPS.QP_SECURITY dependencies on DUAL

Line 810: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;

806: OPEN grant_exist_cur(l_grantee_type, l_grantee_id,
807: p_instance_type, p_instance_pk1, l_object_id);
808: FETCH grant_exist_cur INTO l_dummy;
809: IF(grant_exist_cur%NOTFOUND) THEN
810: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;
811: INSERT INTO qp_grants
812: (GRANT_ID,
813: OBJECT_ID,
814: INSTANCE_TYPE,

Line 897: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;

893: OPEN grant_exist_cur(l_grantee_type, l_grantee_id,
894: p_instance_type, p_instance_pk1, l_object_id);
895: FETCH grant_exist_cur INTO l_dummy;
896: IF(grant_exist_cur%NOTFOUND) THEN
897: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;
898: INSERT INTO qp_grants
899: (GRANT_ID,
900: OBJECT_ID,
901: INSTANCE_TYPE,